InfoPath Dev

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

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. 

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