Expand my Community achievements bar.

Learn about Edge Delivery Services in upcoming GEM session

Opening an Excel Spreadsheet


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


Level 1

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