I've setup multiple dataconnections to use with an Access database in my PDF forms.
I'm trying a new one and I want to use an Excel spreadsheet. However, when I get to the point where I have to select an OLEDB Connection, I select "Excel" and I point it to my excel file. In the Record Source, I have 3 options: Table, Stored Procedure, and SQL Query. Table and Stored Procedure show nothing, even though I do have a table created in the excel file.
What do I need to do as far as as SQL Query to get this to point to my excel file?
I'm using Excel 2010 and Livecycle with Adobe X