Solved

Setting up a Data Connection in PDF LiveCycle using Excel

Posted on 2011-09-28
7
1,451 Views
Last Modified: 2012-07-30
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
Comment
Question by:Michaelwr90
7 Comments
 

Author Comment

by:Michaelwr90
ID: 36761211
Either this is insanely easy that people are laughing at me, or this is impossible? Lol

Any suggestions?
0
 
LVL 19

Accepted Solution

by:
akoster earned 500 total points
ID: 36814285
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
 
LVL 31

Expert Comment

by:James Murrell
ID: 37049362
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
ScreenConnect 6.0 Free Trial

Want empowering updates? You're in the right place! Discover new features in ScreenConnect 6.0, based on partner feedback, to keep you business operating smoothly and optimally (the way it should be). Explore all of the extras and enhancements for yourself!

 

Expert Comment

by:tourtiv
ID: 38228187
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
 
LVL 19

Expert Comment

by:akoster
ID: 38229874
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
 

Expert Comment

by:tourtiv
ID: 38238179
Ok, thank you.  I will do that as soon as I get some free time.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PDF files have been in the limelight due to its unmatched features.  Personal documents, emails, business reports and eBooks are all converted into PDF files owing to peerless features provided by it. Adding watermark to a PDF file is a method to se…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question