How to import a an excel file and execute queries after?

Question

1.00/5 (1 vote)

See more:

SQL-Server-2012

I have this procedure that should import a excel file Using a job and then I have some queries that create some report and after all it export the reports.

But when I execute the procedure The Job Works correctly and it import the excel file but the rest of the codes won't recognize the table that just imported and SQL gives me this error:

Job 'IMP' started successfully.

Msg 208, Level 16, State 1, Procedure Final_Result, Line 7 Invalid object name 'dbo.'New LP''.

(1 row(s) affected)

but when I Refresh the SQL database the table 'New LP' exist. how should I fix this Problem?

What I have tried:

the only way that it works is that I import the file at the first and execute the queries afterward.
But I need to have the import and export in the same stored procedure.
What should I do?

Posted 21-Sep-16 3:20am

Member 11873237

Updated 21-Sep-16 6:37am

Add a Solution

Comments

Karthik_Mahalingam 21-Sep-16 12:01pm

check this object exists in db
dbo.'New LP'

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

David_Wimbley · Answer 1 · 2016-09-21T03:48:00

Given that you haven't provided a sample sql query you are running, I'm going to say it is because you are trying to query out of it by saying

SELECT * FROM dbo.New LP

When instead you need to be using something like

SELECT * FROM dbo.[New LP]

Sql server doesn't like spaces in table names, so when this happens you need to use the brackets like i've shown to query a table with a space in the name.

To replicate, do something like this

CREATE TABLE [Test Data]
(
	Id INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
	Name VARCHAR(20)
) 


SELECT * FROM [dbo].[Test Data]
SELECT * FROM Test Data

You'll see the first query works but the second does not.

Maciej Los · Answer 2 · 2016-09-21T06:37:00

Quote:
Line 7 Invalid object name 'dbo.'New LP'

An error message is quite clear!

Check the name of object and correct it. Enclose the name of object in square-brackets if the name of object contains a space: dbo.[New LP]

For further information, please see: Microsoft – SQL Server – Transact SQL – “Invalid Object”[^]

How to import a an excel file and execute queries after?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0