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
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.
