Excel Table Import into SQL Server 2008

Posted on 2014-07-27
Medium Priority
Last Modified: 2014-07-28
I created a new database called Temp, I used Task/Import to import a table from excel. The table is there and I can query the table and see it's contents. When I try to do a join on the table I get the error below.

Msg 7202, Level 11, State 2, Line 1
Could not find server 'Temp' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Question by:imnee
  • 2
  • 2
LVL 15

Expert Comment

by:Ess Kay
ID: 40223039
save it as a comma delimited  file,  and create an sql to read through the file and insert them
LVL 15

Expert Comment

by:Ess Kay
ID: 40223044
LVL 14

Accepted Solution

Russell Fox earned 2000 total points
ID: 40223301
The problem isn't with the server, it with the query - can you post some or all of the query so we can troubleshoot it? It sounds like you're using an incorrect name: server.database.schema.object. My guess is that the join should be "JOIN dbo.Temp ON..."

Author Closing Comment

ID: 40223974
Correct. I have the column name CompanyPartMasterId as part of the reference to my table.

INNER JOIN Company.dbo.Plating.CompanyPartMasterId spm1 on spm1.CompanyPartMasterId = spm.Company_Part_Master_ID
LVL 14

Expert Comment

by:Russell Fox
ID: 40224526
So you took out the column in the join?
INNER JOIN Company.dbo.Plating spm1
    ON spm1.CompanyPartMasterId = spm.Company_Part_Master_ID

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question