Home > IT Answers > Business Intelligence > Exporting Data to Text/CSV file in SQL Server 6.5
Kpatel
0 pts.
 Exporting Data to Text/CSV file in SQL Server 6.5
Database Management Systems, SQL Server
Hi, I would like to know how do we Export Data to Text/CSV file in SQL Server 6.5 Do we have something similar to DTS in SQL Server 2000? Thanks, Kruti

Software/Hardware used:
ASKED: March 24, 2005  3:37 PM
UPDATED: March 24, 2005  6:11 PM
RELATED QUESTIONS
Answer Wiki:
Can't help with SQL Server 6.5, but SQL Server 2000 does have DTS. I have used it for both importing and exporting data.
Last Wiki Answer Submitted:  March 24, 2005  3:50 pm  by  Stanton   0 pts.
All Answer Wiki Contributors:  Stanton   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

If possible, I suggest you import from ODBC datasource (SQL 6.5) using Excel. Then save as CSV in Excel. This should be far easier than trying to find support for SQL Server 6.5 tools.

Good luck

BeerMaker
 0 pts.