Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Opening an Excel Spreadsheet

Avatar

Level 1
I have a sample code to access a Microsoft Access Database from Acrobat. It works fine in version 7.



However, I need to create a form (deposit slip) which must link to an excel spread sheet for the actual data.



I have made the necessary adjustments (creating another DNS with the Excel driver, changing the code, etc.) but I cannot get a connection.



The second problem is in that, the Access sample code uses SQL to query the access Database, but I am not so sure if that will work with Excel since Excel doesn't have a field structure like a regular Database, or tables to chose from.



My questions are:



Does any body have a sample code for:

1. Connecting Acrobat or designer to an Excel spread sheet

2. Querying the spread sheet and retrieving the columns that I need



I will create an altar for anybody with a solution, and I will worship him/her for at least 3 days.
1 Reply

Avatar

Level 1

Wow.  This was posted in 2002 and there's still no way to gather submitted  form data automatically into Excel.   Crazy.