Importing data from Excel to generate "filled" PDF form that was created in Designer

[nizarjr]

Hi there

I have a form that was created in Designer.  The data that  I need to import is all in a Excel spreadsheet with the same fields as the form.

Is it possible to import all the data so that it generates a printed PDF with the data on each line of excel?

For example:

If my excel file shows:

First Name      Last Name     Phone Number        UserID

John               Doe               416-777-9970           johndoe997

Mike               Rogers           905-887-3398          mikerogers997

In this example I would like to generate a PDF form for John and for Mike, each with their details filled out on the form based on the data in the excel sheet

Thanks in advance!

[jnicholas330]

LiveCycle is an XML centric tool. You might be able to save your excel spreadsheet as an XML file and import it that way. Good luck!

[nizarjr]

i can certainly do that but how would i go about importing it?

[jnicholas330]

Assuming you have Adobe Acrobat 11:

[nizarjr]

This only imports 1 entry at a time though doesnt it

[jnicholas330]

No, it will import as much as is in your spreadsheet. However, your form must be setup to allow for repeating data groups or you may end up seeing only the first record.