Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1592
  • Last Modified:

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
0
Michaelwr90
Asked:
Michaelwr90
1 Solution
 
Michaelwr90Author Commented:
Either this is insanely easy that people are laughing at me, or this is impossible? Lol

Any suggestions?
0
 
Arno KosterCommented:
Does the path & filename combination of the referenced excel file contain spaces ?
eg. C:\Documents and settings\....\spreadsheet.xls

Apart from this, you could use a query like

Select * FROM [Sheet1$]

Open in new window

0
 
James MurrellProduct SpecialistCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
tourtivCommented:
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
0
 
Arno KosterCommented:
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.
0
 
tourtivCommented:
Ok, thank you.  I will do that as soon as I get some free time.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now