These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Data connecto to an Excel file

Forum Index > Rich Media/Flash > Data connecto to an Excel file
2007-03-27 16:06:41
Jesus
Registered: Mar 27 2007
Posts: 54

I'm trying to create a data connection in a form in Adobe Lifecycle 8.0 to acces an Excel file. I have done the following":
1- Created the spreadsheet with tha data that I need
2- I created the ODBC(System DNS)
3- Start creating the data connection and select the data source but when try to select the Record Source nothing appears to be selected.
 
What am I missing?
 
Please help me.
 
Thanks,
 
Jesús

My Product Information:
Acrobat Pro 8, Windows
Top
2007-03-29 09:50:56
#1
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
I'm sorry to say that I have not been successful at connecting an Excel file to a Designer Form. I haven't found any Adobe docs that are helpful. A search of the forums return a few people that have asked this same question and gotten zero response. I found two forum messages where someone said they had connected to an Excel file. Here's the most verbose one.
[url=http://www.adobeforums.com/cgi-bin/webx/.3bbf8daa]http://www.adobeforums.com/cgi-bin/webx/.3bbf8daa[/url]

The real issue seems to be the driver used to make the connection. As you've pointed out, the one that comes with windows doesn't seem to allow an excel worksheet to be specified for the connection table. It may be there is a trick to getting around this. A setting somewhere, but I haven't found it. Look at the forum where the above link is at and write the guy who has the working connection and see what driver he's using.

Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script

Top