Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Import CSV File Expand / Collapse
Author
Message
Posted Thursday, June 13, 2013 4:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 30, 2015 9:49 AM
Points: 145, Visits: 533
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-------
Post #1462972
Posted Thursday, June 13, 2013 5:53 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:26 AM
Points: 14,326, Visits: 37,416
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

--
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!
Post #1462996
Posted Thursday, June 13, 2013 8:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 30, 2015 9:49 AM
Points: 145, Visits: 533
Thanks ..........its working fine now........
Post #1463131
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse