Post reply

Import data from a file into a SQL table

  • March 11, 2010 at 3:14 am

    #216478

    I want to insert data from a csv file into a SQL table. The data must go into specific columns and the data in the table must be overridden. How can I do this?

  • March 11, 2010 at 4:44 am

    This was removed by the editor as SPAM

  • March 11, 2010 at 5:55 am

    #1131962

    Also:

    BULK INSERT (Transact-SQL)

    OPENROWSET(BULK...)

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • March 11, 2010 at 12:40 pm

    #1132270

    That's all I've been doing for the last few weeks. I have a number of csv files (all of which are different) that I need to extract data from and store in SQL. Some of the files contain rows of comma delimited variables. Some have rows that consist of variable name, data, variable name, data etc...Some of the files contain many differently formatted rows that I have to pull data from. SSIS handles all of these without too much trouble. I went through the tutorial below and it told me most of what I needed to know. What does your data look like?

    http://msdn.microsoft.com/en-us/library/ms167031.aspx

  • March 11, 2010 at 2:00 pm

    #1132310

    You can also use the import wizard. Right-click on the database in the object explorer. Select Tasks --> Import. From the there, the wizard will guide you. Behind the scenes, it creates a SSIS package which you have the option to save if you wish.

    Converting oxygen into carbon dioxide, since 1955.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply