DTS Import | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS Import

I have created an DTS that is supposed to import fields from an excel file into a sql table, but when I run the DTS I keep getting the following error message: Error Source: Microsoft JET Database Engine
Error Description: The Microsoft Jet Database engine could not find the object. Make sure that the object exists and that you spell it’s name and the path name correctly.
Has anyone come across this before? How did you manage to resolve it? Jason
The table doesnt exist in the Access Database
Make sure it is there Madhivanan Failing to plan is Planning to fail
I am not using access. I am using a Microsoft Excel file.
Then The Execl File or the Sheet is missing Madhivanan Failing to plan is Planning to fail
The file name and location are correct.
As an alternative try this
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=8440 Madhivanan Failing to plan is Planning to fail
quote:Originally posted by quailj1973 The file name and location are correct.
but the sheet name is not.
Try creating a fresh DTS pkg making sure the file name and the path is correct. Thanks!
"He laughs best who laughs last"
Apart from DTS another option might be to create an Excel sheet using the Excel.Application object and an Excel macro. It is possible to invoke an Excel macro from TSQL (using sp_OAmethod) but DTS is really much simpler to setup unless you need to implement features that are only accessible via the Excel API. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>