SQL Server Performance

DTS Import

Discussion in 'SQL Server DTS-Related Questions' started by quailj1973, Nov 9, 2005.

  1. quailj1973 New Member

    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

  2. Madhivanan Moderator

    The table doesnt exist in the Access Database
    Make sure it is there

    Madhivanan

    Failing to plan is Planning to fail
  3. quailj1973 New Member

    I am not using access. I am using a Microsoft Excel file.
  4. Madhivanan Moderator

    Then The Execl File or the Sheet is missing

    Madhivanan

    Failing to plan is Planning to fail
  5. quailj1973 New Member

    The file name and location are correct.
  6. Madhivanan Moderator

  7. mmarovic Active Member

    quote:Originally posted by quailj1973

    The file name and location are correct.
    but the sheet name is not.
  8. Reddy New Member

    Try creating a fresh DTS pkg making sure the file name and the path is correct.

    Thanks!
    "He laughs best who laughs last"

  9. satya Moderator

    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.

Share This Page