InfoPath Dev

I have a strange problem. I have created an infopath form with full trust and my own digital signature. I am acessing SQL database and exporting data to Excel on button click. This whole process works perfectly fine if I run it in debug mode. But somehow, when in preview mode, the button event is not firing and the expect SQL execution/excel ...

Thanks Clay..

Is there any way to export data from a repeating table to an excel sheet on click of button? (i.e. it should be done programatically.. The user should be able to click a button on the form and the data should be transferred to the excel sheet - without having to use any export wizards) Note: The repeating table is populated with data from a ...

I have a repeating table which gets data dynamically from an SQL database/webservice. On click of button, I need to transfer data from repeating table to an excel sheet. This has to be done on button click (programatically) and not via the export wizard. Is this possible? Please help!!