Post reply

Importing Selected Columns from CSV to SQL 2008

  • July 2, 2010 at 1:14 pm

    #237288

    Hi

    I'm new to Database. I have a CSV file with 20-25 columns and want to import only selected columns from this file into my table. Say I have columns like 1,2,3,4,5,6,7,8,9,. How do I import only columns 1,3,5,6. Can you guys give me any Idsea to Do that.

    Thanks

  • July 7, 2010 at 6:59 pm

    #1189943

    Novicejatt, again, this is a 2000 forum, and it seems like maybe you have 2008? Anyhow, as far as the one time uploads are concerned, I personally find OPENROWSET the easiest method for the Excel files, but that is just me. You can find out all about in BOL.

    Greg
    _________________________________________________________________________________________________
    The glass is at one half capacity: nothing more, nothing less.

Viewing 2 posts - 1 through 1 (of 1 total)

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