Import CSV File

  • 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-------

  • 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!

  • 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