I am trying to connect a Listbox on a static PDF form to a XLS file. The user should be able to select on the PDF form an item of the listbox which is has been feeded by the xternal Excel file. I need to insert one row of two columns (e.g. cell A1 and cell B1) into the on line of the listbox.
Alternatively it would also work out with TXT file.
The textfile is looking somhing like below and contains a lot of lines...
The XLS file (or the TXT file) are located in a folder relatively to the PDF (i.e. "c:\test\subfolder" or "e:\abc\subfolder").
Is such a "data connection" possible?
I don't know of a way to connect to an Excel file. You can connect to an XML schema, OLEDB database, sample XML data or a WSDL file but I believe you'd still need to save the form as dynamic for any of these to work.
It is possible to connect an Excel file to a datasource.
You need to define the Excel sheet in the ODBC data sources on each machine that will use the form.
Connections to local Excel files or Access databases can be problematic.
A WSDL, or other independant data source is usually more stable / reliable, and easily shared.