asked on

Setting up a Data Connection in PDF LiveCycle using Excel

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

Michaelwr90

ASKER

Either this is insanely easy that people are laughing at me, or this is impossible? Lol

Any suggestions?

ASKER CERTIFIED SOLUTION

Arno Koster

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

James Murrell

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

tourtiv

Can this post be re-opened? I have some follow-up questions; I was able to get my form to grab the information from the spreadsheet, but I can't get it to populate it with the entire spreadsheet, it's just grabbing the first row. Any help would be greatly appreciated.

Thanks

Arno Koster

If you open a new question i would be more than happy to assist you.
Futhermore, by opening a new question you would also invite other experts to take a look as well.

This will lead to a better answer.

tourtiv

Ok, thank you. I will do that as soon as I get some free time.