Infopath

[Jack]

I am trying to generate infopath forms that are based on a sharepoint list
and/ or Excel/Access database.
I would like to create a form for each record i.e. each row in the
list/database should be saved as a form under a seperate name. This needs to
be an automated process as there are over 2,000 records in my database.

 

[S.Y.M. Wong-A-Ton]

You can manually create a form template based on the information from your
list or database (fields to go on the form), fill out the form and save it
locally to see what the structure of its XML would be like, and then use code
to loop through your list or database records to create an XML file for each
form. Note that the code to loop through the list or records in the database
would be outside of InfoPath in a Console or Windows application.