Exporting SQL Server Data to Excel through InfoPath

[Shane Stimpson]

Hey,

I've got a few InfoPath forms that are tied to SQL Server databases.
Whenever I try the Export to Excel option, I cannot select any tables, and it
only exports the fields I created for some controls, not the user-entered
data. What can I do just to get the data entered in the form into a
spreadsheet. I don't want all the data like querying, and I kind of would
like some control as to how is outputs into excel (not just one field per
column, but more like it is on the form). Thoughts?

Thanks in advance,

Shane