Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Importing Excel Data into Designer Form

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

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

Avatar

Level 2

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