Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 export SQL 7.0 data to a csv text file from asp

Author  Topic 

matt_calhoon
Posting Yak Master

235 Posts

Posted - 2001-06-06 : 23:55:32
Hi there,

I need to set up a web page that will allow the user to download the latest data from a SQL 7.0 DB table. Is this process possible:

1. User clicks download button
2. asp page calls up SQL to grab data and export to a csv file located on the server (using DTS??)
3. file is downloaded to client
4. Clients SQL 6.5 DB imports this data into table.

The client did not want replication!

any comments would be appreciated.

Matt

   

- Advertisement -