Solved

Setting up a Data Connection in PDF LiveCycle using Excel

Posted on 2011-09-28
7
1,495 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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:
Arno Koster 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

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:Arno Koster
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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

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…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

707 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