Discussion Locked

Export SQL Data to Flat File in ASP.NET

0 helpful

1 reply

by bgibilaro Apr 8, 2003 last reply Jun 9, 2003

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to create an simple web app that will allow our client to query a SQL database and then export the returned recordset to a flat file.

I am using ASP.NET to develop this app.

In ASP.NET, how can I take a returned recordset and save the info to a flat file on the user's computer?

Any help would be greatly appreciated.

Thanks!

Bob Gibilaro

1 reply

I did something similar using Classic ASP and a DB to generate local XL/CSV files.

You can use the FileScriptingOject to write the file out as a CSV or do something like that shown at http://www.greggriffiths.org/webdev/both/excel/

This discussion is closed to new replies.