SQL Database Integration

Re: Exporting data from Infopath Form

Bscowcroft — Tue, 07 Oct 2008 20:56:50 GMT

Sandya

Thanks for your tips. Unfortunately they do not help. We are using infopath2003 and I want to try and not use the export wizard. I was hoping for some code which I could attach to the approve button which would do the export.

Cheers

Brian

Re: Exporting data from Infopath Form

sandhyapati — Tue, 07 Oct 2008 04:39:24 GMT

Hi,

Can you go through the below links

http://office.microsoft.com/en-us/infopath/HP010968191033.aspx

http://office.microsoft.com/en-us/formsserver/HA102142261033.aspx

For Import an Excel Spreadsheet into an Access database go through the following links http://databases.about.com/od/tutorials/ss/exceltoaccess.htm

http://www.microsoft.com/technet/scriptcenter/resources/qanda/apr07/hey0404.mspx

I hope they might help you.

Exporting data from Infopath Form

Bscowcroft — Tue, 07 Oct 2008 03:37:47 GMT

I have a corporate infopath form that a work area would like to gather data from. The form has already been developed and approved for release so I cannot change the Main data connection. I have been looking at exporting to excel and then importing into a local access database. The export wizard is a little clunky. Is there a way for me to code the export behind and approve button to export the data to a spreadsheet stored in a set folder. Then I could import and then delete said spreadsheet from the access database. (I know the form should just be redone with the new main source but the politics get in the way).

Thanks in Advance

Brian