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)
 exporting sql server data to csv file

Author  Topic 

sachingovekar
Posting Yak Master

101 Posts

Posted - 2009-10-27 : 00:43:03
Hi,

I want to export millions of records from sql server table to csv file.
I noticed rows data getting shifted to other columns.
What can be the best strategy to import.
I am directly exporting from Microsoft SQL SERVER 2005 MANAGEMENT STUDIO.

for eg:
user department city
micheal clark finance texas

clark is a surname which has got shifted to deprtment column anD FINNACE TO CITY column


Kindly help.
Regards,
Sachin
   

- Advertisement -