Solved

Setting up a Data Connection in PDF LiveCycle using Excel

Posted on 2011-09-28
7
1,465 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
Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

 

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

828 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