Retrieving data from Infopath on SharePoint to Access?

[Eli]

I developed a form in InfoPath and it needs to be posted onto a SharePoint
site. When an customer is finished filling out the form via SharePoint that
data needs to go to an Access database. I have tried to use the “wizards†in
all three applications but it’s basically not working. The form is on the
SharePoint site but there is no practial “connection†between SharePoint and
Access. The connection made gives me a "SharePoint List" and does not
download the actual data from the form. How do make the connection to
retrieve all data from the InfoPath forms hosted on SharePoint and downloaded
to the Access database.

Any advice would help.

Thanks

 

[Mikail GULER]

Hello Eli,

At firstly you must import a table schema from Access or Ms SQL Database.
Then you must put a button that has a query function onto your infopath
form.( You do not need a connection on sharepoint.) When the button click
then data will be retrieved.

Yours sincerely,

Business Analyst
/etcBASE Software and Information Tech.
Turkey