Data from Access table to a Infopath Form....

[konquistador]

Hi Guys,
I have an Access database which has many tables.
I have also created a Infopath form template and published it to Sharepoint server.
Now, My question is: How to get the existing data from
an MS Access Table to a Infopath form? I need to create a Infopath form for each row in the Access table(assuming the field names are same in both Access and Infopath)
Do i need to build a Infopath form on that Access DB or
Is this something that i have to work on Access?

Thanks,
Kon

 

[konquistador]

Infopath form .xml from an Access table....

Hi guys i think i am very close....and i need some valuable suggestions.
Here is what i have done....
I have imported Data from an Access database into sharepoint by:
1) First Importing the Access table to a Sharepoint List
2) In Infopath i created a new Connection to receive data and
3) Created a text box in Infopath and in the Datasource Option--> default Value , i selected the
field name from the secondary data source.
But here i can only see the first row values prefilled in my Infopath form.
How do i create a Infopath Form(a .xml file) for each row of the table.

P.S : How to move data from access to sharepoint.

http://www.sharepointblogs.com/ssa/archive/2007/09/04/importing-ms-access-data-in-infopath.aspx