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

importing Excel spreadsheets

Forum Index > PDF Creation > importing Excel spreadsheets
2007-03-25 13:44:16
tkds
Registered: Mar 25 2007
Posts: 4

hello, I have currently designed a form using Acrobat 7 and designer. I am very happy and my client is happy with how my form looks. however, I need to find a better way to import the information into it. currently I am pasting it out and an Excel spreadsheet that was poorly created. I have 12 of these to do today but will have many more in the future. So I am looking for a solid solution on how to create data from these Excel spreadsheets into my forms? I am using Excel 2003 but my client is using Excel 2007. I appreciate any help you can offer.

My Product Information:
Acrobat Pro 7.0.0, Windows
Top
2007-03-26 10:29:18
#1
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
Have you looked at the Data Connection options in Designer? You may be able to connect the form directly to the Excel spread sheet. Look on the "Data View" tab. Create a new connection and select the ODBC driver, then from the ODBC drivers select an Excel connection. There are some samples on the Designer forum site and some that come with Designer. I don't know if there is a specific example of what you want. You'll need to do some reading and experimentation to nail down your solution.

Look here for more info:
[url=http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=330467]http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=330467[/url]

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

Top