Importing from Excel to SQL Server 2005 Express RRS feed

  • Question

  • I'm trying to import a database. It seems my most likely route is via Excel, so I've moved my tables in there.

    Then I tried setting up Excel as a linked server as described in http://support.microsoft.com/default.aspx?scid=kb;en-us;Q321686

    My linked server gets created apparently with no errors, but I can't see any contents when I click on it in the object explorer.

    Anyone with more clues than me?


    Wednesday, January 18, 2006 8:17 PM


All replies