These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

I connected to excel DB/table but I need to select specific rows

ebbo1983
Registered: Mar 16 2009
Posts: 93

Well rather then blabber on too much, I have sucessfully made a ODBC connection to an excel file (you can see the excel file in my screenshot)

I have added 3 dataconnections, each links to a different table in the excel file. (is this neccessary, can I not make 1 data connection to the entire file?)

Anyway I kind of have it working, you can see from the preview row 1 is output. But say I wanted to skip row 1 and go straight to a specified row of my choice say row 5 etc how would I set this within livecycle?

[img]http://img214.imageshack.us/img214/2726/dbconnection.jpg[/img]

ebbo1983
Registered: Mar 16 2009
Posts: 93
any help in this please?
gkaiseril
Expert
Registered: Feb 23 2006
Posts: 4308
Have you read [url=http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/]Selecting Specific Database Records[/url] by Stefan Cameron. A knoledge of SQL will help.

George Kaiser