InfoPath Dev

Hi. I would like to know how would it be possible to export to excel the information from SQL database using InfoPath customized code. To be more accurate: I extract some information from the database on the form in a repeating table for example and the information I see on the form I want to export it to excel. I am also interested in any form of reports I can create in InfoPath, so any suggestion is welcome. Thank you!

Hi There, Hope you've already done it by this time. Here is my solution to export to Excel by clicking a button for one of my query forms. If you have query, please let me know. Thanka, Ash

string qyear = DOM.CreateNavigator().SelectSingleNode("/dfs:myFields/dfs:dataFields/d:qYear/@qYear", this.NamespaceManager).Value;

string filename = qyear + "_" + period;

this.CurrentView.Export(@"G:\...\Trends_totaltrans_" + filename + ".xls", ExportFormat.Mht);