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
 General SQL Server Forums
 New to SQL Server Programming
 .csv files with more than 256 columns

Author  Topic 

katarina07
Starting Member

31 Posts

Posted - 2008-02-06 : 11:44:22
Hi,

I have a .csv file which has many columns so that I cannot open it in Excel or Access.

Is it possible to open it in an output grid of SQL Query Analyzer?

Or is there some other tool to open .csv files with many columns?

Thanks
Katarina

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-06 : 23:13:05
No, but you can load it to sql table with bcp or bulk insert.
Go to Top of Page
   

- Advertisement -