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.