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"
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:
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!