Exporting Database to .txt or .csv?

[tlcable7]

Does anybody know how to export recordsets as tab delimited text or Ecxel files? I need to bundle the data up to send to some clients.

I have heard that there is a way to set the Doctype of a page to an excel format, and then make the excel version available online...?

Please Help.

Travis Cable

 

[TheBugSlayer]

Assuming you are talking about an SQL table, you could in Enterprise Manager right click on the DB or table and in the menu choose All Tasks|Export Data. In the secong step in the wizard choose your destination format. In your case choose Text file, MS Treiber, Excel or whatever format you would like the data exported to.

 

[tlcable7]

What about an online form that creates an SQL Query based upon user selections. Could I pull the data from the database and instead of displaying it in a HTML table, put it in an online Excel Spreadsheet?