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]