troubleshooting Question

SSMS Imprt data from Excel

Avatar of Allen Pitts
Allen PittsFlag for United States of America asked on
Microsoft SQL Server 2005
7 Comments1 Solution199 ViewsLast Modified:
Hello expert,

Have built table in SQL Server Management Studio with create table statement
copied herewith below.
Now trying to get data into it from Excel spreadsheet.

So I Googled it and got some direction. The instructions say to open the Import Export Wizard
by going to the database icon in the tree (not the Table icon)  and choosing Tasks>Import Data.
This gets me to the Wizard. It asks me about the Data Source and the path to the Excel Worksheet.
(I work for a healthcare company so we have old tools, SSMS ver 9 and SQL Server 2005. So
I and to convert the Excel from xlsx to xls because the SSMS ver 9 doesn't know that xlsx files
Then it goes to Choose a Destination and this where the problem is. It allows a choice for
destination like Microsoft OLE DB Provider for SQL Server and SQL Native Client. I chose the former.
And the Server Name can be chosen and the Database. But it does not allow me to say which table in which to
write the data. It then asks me about the table to use in the table Export Worksheet$.
On the Complete the Wizard dialogue box it says it will copy the Worksheet to [TempData].['Export Worksheet$']
and the new table will be created.
A new table is not wanted. The data should be copied into the existing table.

Where does it let me choose the table?


Allen in Dallas

CREATE TABLE SFA.tempCrossInsurance
EMPLOYER_NAME varchar(50),
SERV_PCKG_NAME varchar(50),      
SERV_PCKG_ID int,      
PYR_PCKG_NAME varchar(50),      
MARKET_ID int,      
MARKET_NAME varchar(50),      
Database Consultant
Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros