Post reply

Moving data from Excel to Sql Server

  • March 3, 2005 at 5:51 am

    #66511

    I need to move data from Excel spreadsheet into table. 2 columns in spreadsheet need to be concatenated. Don't know excel at all - is this straightforward? Should I format spreadsheet or export data and format after transfer.

  • March 3, 2005 at 6:02 am

    #545177

    Hi Louise,

    It will be as easy as you make it.......

    If its as simple a crossover as you make it sound, a DTS package would be a simple way forward. 1 connection to the spreadsheet, 1 connection to the database and you can do all the transformation of data you want in between.

    Have a look on here for pointers:

    http://www.sqldts.com/default.aspx?1

    Have fun

    Steve

    We need men who can dream of things that never were.

  • March 3, 2005 at 6:20 am

    #545183

    If it is just a one-time issue and you have no experience with DTS, you can import the data into SQL table as they are and concatenate after. If you'll be doing it repeatedly, then decidedly go for DTS - it is worth learning anyway

  • March 3, 2005 at 11:51 pm

    #545385

    Quickest way I found so far is to save the excel file as a CSV file. Import the CSV file into SQLServer as a new table... then you can use queries to get what u want.

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

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