Home Forums SQL Server 2005 SQL Server 2005 General Discussion Import Excel Spreadsheet RE: Import Excel Spreadsheet

  • October 2, 2010 at 2:59 am

    #1230669

    Clkgtrs1 (10/1/2010)

    Hey Thank you for the help but when I right click the database I don't have the option to import data into my database. I'm running SQL Server Management Studio Express 2005 is there an upgrade that I should perform?

    It should be under the Tasks sub-menu.

    You can also use the OpenRowSet / OpenDataSource functions:

    SELECT *

    INTO dbo.MyNewTable

    FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\test\xltest.xls', [Customers$])

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2