Importing Multiple Worksheets On Excel To Single Table
Posted on 2011-05-11
Began supporting a new production system quite recently, with SQL Server 2005 as backend. Had call from user today from user who was trying to import Excel spreadsheet via the SQL 2005 Importr/Export Wizard - user was trying to import all four worksheets from spreadsheet into single table in SQL Server 2005.
Import was failing with error message along lines of :
The same destination table name TARGETTABLE is used more than once. All destination table names must be unique.
User mentioned that they had been able to do this previously without any problems under their old SQL Server 2000 box - logged onto that box, and I was able to import all four worksheets from spreadsheet into single table in SQL Server 2005.
Any ideas on how this can be done in SQL 2005, given this apparent restriction in SQL 2005's Importr/Export Wizard.