Expand my Community achievements bar.

Opening an Excel Spreadsheet

Avatar

Former Community Member
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.