June 13, 2013 at 4:36 am
Hi,
I have a 4 GB CSV file , which i am unable to import in SQL Server 2008 R2, even I not able to open file also. I tried import export wizard also but when i am importing the file , it displaying the records with double quote("").
For Ex:- "Charles"
"$1.2"
Is there any alternate option to import large file into the SQL SERVER or any third party tool which will import the file without double quote.
Thanks in advance-------
June 13, 2013 at 5:53 am
arooj300 (6/13/2013)
Hi,I have a 4 GB CSV file , which i am unable to import in SQL Server 2008 R2, even I not able to open file also. I tried import export wizard also but when i am importing the file , it displaying the records with double quote("").
For Ex:- "Charles"
"$1.2"
Is there any alternate option to import large file into the SQL SERVER or any third party tool which will import the file without double quote.
Thanks in advance-------
the import wizard, bulk insert or sqlcmd.exe/bcp.exe are your best choices, especially for large files.
since you got the import wizard to work, i'd suggest redoing it that way; it sounds like you missed selecting the text qualifier (of dbl quote) , because your data is delimited with it.
change this setting and rerun it again:
Lowell
June 13, 2013 at 8:43 am
Thanks ..........its working fine now........
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply