raymurphy
asked on
Importing Multiple Worksheets On Excel To Single Table
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
lcohan, this approach is fine from a developer/dba perspective but would not be suitable for the end-users themselves.
Thanks for both comments.