Post reply

DTS Data Import Error: Excel Source

  • July 15, 2009 at 1:09 pm

    #223597

    Hi,

    I am sourcing data from any excel file using DTS and I get the following error message.

    "Error Source: Microsoft JET Database Engine.

    Description : External table is not in the expected format. (Microsoft JET Database Engine)

    Context: : Error During Initialization of the Provider"

    Any help is greatly appreciated.

    Thanks,

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

  • July 15, 2009 at 1:22 pm

    #1025307

    What EXCEL revision are you using pre 2007 or 2007? Note that 2007 uses a different driver.

    This forum may have what you need if you are using 2007

    http://www.sqlservercentral.com/Forums/Topic477652-148-1.aspx

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • July 15, 2009 at 1:42 pm

    #1025323

    I am using Excel 2003.

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

  • July 15, 2009 at 7:34 pm

    #1025438

    cos_ta393

    I have found this to be an excellent source for importing data from Excel, hopefully it will have enough information to assist yourself.

    http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

    Another good read is:

    http://www.mssqltips.com/tip.asp?tip=1202

    Both sites contain sample code. If these do not help solve your problem open a new forum and post your request for help once again.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • July 17, 2009 at 1:23 pm

    #1026402

    bitbucket -

    Thanks a million for these links they are really helpful. I however figured out what my issue was. I found out from the DBA that my excel file is in fact an HTML file saved as Excel which explains why DTS could not recognize the format. We will be getting the file as a raw data dump in the coming weeks.

    Thanks for all your help..

    - cos_ta

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply