Posted by Erland Sommarskog on 11/22/07 22:46

Frank (darkwarmbreeze@yahoo.com) writes:
> I have a CSV file that i need to import into a SQL table. The problem
> is the values in the first column are not brackited in "". There are
> over 700K rows. Is there an easy way to fix the data or have SQL
> correctly import the the data?
>
> The data looks like this
>
> 1, "xxx","zzz"
> 2, "aaa","bbb"
> an so on...

Which version of SQL Server? Which import tool do you want to use? I could
give the answer for BCP, but if that is not what you are using, it would
not help you...


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: foreign keys - on which kind of keys do the base on?
• Prev in forum: Re: SQL Server Express 2005 @@SPID
• Thread view: Re: importing a CSV file

[Reply to this message]