Importing Excel Data into a LiveCycle Text Field

@ Jennifer

Hi,

try to start with this tutorial by Stefan Cameron. It's very beginner friendly.

http://forms.stefcameron.com/2006/09/18/connecting-a-form-to-a-database/


Later you can go ahead with this one.

http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/

I have looked through the tutorials above, but saw no reference to importing a particular xls cell data (it just taked about importing databases.) I have a LiveCycle form that needs to import information from an Excel cell. There are numerous places throughout my form where I need to import various cell data. In other words, I need some type of command in the text box that says the value of the text box = [file path / spreadsheet name / worksheet / cell column and row ID]. Any ideas?

You can create a named area or range within an Excel file and that area will work like a table in a database.

Thank you for the response. Please forgive me - databases (and frankly, Excel spreadsheets) are not my expertise (far from it!) I have about a hundred cells that I need to link to throughout my form. Would I need to "create" a database for each one of these? What do I do with the database once I define it in Excel... How do I import the data into a .pdf? Would I need to create a schema for each spreadsheet? (One of the tutorials mentions creating a schema.) ... I need any help you're willing to provide. Thanks!!!

Hi, I am trying to also link specific cells to fill in fields on an Adobe livecycle pdf (or just plain pdf if that works better). Jennifer, did you figure this out?