Is it possible to create a form that allows users to import data from an excel spreadsheet

[Former Community Member]

I have not been able to start my reading on scripting or other livecycle features to be able to try to figure this out but I was wondering if anyone else had ever created a form with this feature or had any ideas of how it would be possible.  Our company currently uses and excel form that would have a variable number of rows of data for each time it is filled out and we would be replacing it with an adobe form.  I would like to know if the users, who will be using the new adobe form in adobe reader, could have the capability to imort the lines from the previous excel form into the new adobe version.

[Niall_O_Donovan · Accepted solution]

Hi,

You can set up a data connection with an Excel spreadsheet. However for the data connection to work for users with Reader, you would need to Reader Enable the form with the LiveCycle Reader Extensions ES2.5 (server component). See here for summary: http://assure.ly/etkFNU.

However if you are just trying to get the existing data into the form, you should have a look at some of Stefan Cameron's posts: http://forms.stefcameron.com/ (try a search). You can start a new form using the wizzard and select import from Excel. This will allow you to paste from your spreadsheet to a new form. This should help set up the data structure/schema, which you can then replicate in a new form. I haven't done this before, but it should be possible.

Hope that helps,

Niall

[Former Community Member]

That was what I needed to know, Thank You!

It looks like my best option might be programming excel to "fill out"

the adobe form simply by using the correct key sequence and copy/paste

the lines into the correct spots on the adobe form.

That is not ideal but we will have several hundred properties that

currently have an excel version of the form that we will be moving the

information into Adobe forms for so it will save our processors time if

the copy/paste is automated.