Is it possible for a user with Acrobat Reader 7 hitting a button to import
data from an Excel file?
If yes how I can accomplish the above.
The Excel file will be locate somewhere in a network Drive.
If the data is save from Excel as a Tab Delimited file you can use the "doc.importTextData()" function. In the JavaScript reference it states that the PDF requires "Form" Rights for this to work in Reader and you cannot specify the path to the file. Instead Acrobat will display a file open dialog. So it's not a completely hands off solution for the user.
I am also assuming that the form rights provided by Acrobat 8 are enough to make this work in Reader. I haven't tested it.
I have not had success with connecting to Excel from ADBC, even though there is an ODBC driver for it. ADBC is not available in Reader.
If the data is save from Excel as a Tab Delimited file you can use the "doc.importTextData()" function. In the JavaScript reference it states that the PDF requires "Form" Rights for this to work in Reader and you cannot specify the path to the file. Instead Acrobat will display a file open dialog. So it's not a completely hands off solution for the user.
I am also assuming that the form rights provided by Acrobat 8 are enough to make this work in Reader. I haven't tested it.
I have not had success with connecting to Excel from ADBC, even though there is an ODBC driver for it. ADBC is not available in Reader.
Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script