Importing Excel Data into Designer Form

[zann1313]

I have developed a dynamic form in Livecycle designer that will be sent out to hundreds of schools throughout Nebraska.  There is a table within this form that has buttons to add or delete a row so that mutilple students' informtion can be entered into this table. The way I have the form set up now will work perfect for most schools, however; with larger schools that will need to enter over 200 different lines of information, this will be an unessarily long task.  Most of these schools already have the information that we are requesting in an Excel file.  Is it possible for an end-user of this form, using adobe reader, to import excel data into the table?

-Susann Wenzl

[Former Community Member · Accepted solution]

It is possible but you might find it more trouble that what it is worth.

1. You would have to manipulate the Spreadsheet to make it look like a DB

2. You would have to set up an ODBC connection on the system that is running the form and the spreadsheet..

3. You would have to modify the definition in the form to point to the SpreadSheet

4. You would have to Reader Extend the form using LiveCYcle Reader Extensions to allow the ODBC conection to happen in Reader.

Paul

[zann1313]

Okay, so I had to have one of our programmers come over and translate your response to me. He further explained the process, and it will be more trouble than it is worth. Thanks for your help.

Susann K. Wenzl

Curriculum, Instruction, and Innovation Team

Nebraska Department of Education

301 Centennial Mall South

Lincoln, NE 68508

Phn: 402-471-6692

Fax: 402-471-0117