Import data from a file into a SQL table

  • hardus.lombaard

    Grasshopper

    Points: 24

    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?

  • This was removed by the editor as SPAM

  • Paul White

    SSC Guru

    Points: 150442

  • nano2nd

    Hall of Fame

    Points: 3073

    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

  • Steve Cullen

    SSCertifiable

    Points: 5598

    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 5 (of 5 total)

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