Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011
    Posts
    78

    Unanswered: export data from excel 2007 to MS SQL server 2008?

    Anyone know how to export data from excel 2007 to MS SQL server 2008?

    I have four thousand rows of data, I wonder if I can put in all the data without copying and pasting so many time. Please let me know. Thank you.

  2. #2
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    One (easy) way is using SQL Server Integration Services, or you may have a look at the following link: bulk insert
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

  3. #3
    Join Date
    Jul 2011
    Posts
    78
    Thanks for the link. I will look into it.

    I tried using this, but got some red stuff near the file address C:\ . Anyone know why?

    How to import data from Excel to SQL Server

    Use a Linked Server:


    SELECT * INTO Dates FROM C:\Documents and Settings\bt\Desktop\Optimum_west_join_tables.xls[Dates]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •