Sunday, March 11, 2012

DTS and Excel 2003

We have a DTS package that imports data from a client's Excel file. Previously our client was using Excel 2000, but recently they upgraded to Office 2003, and now suddenly when I try to view the transformation task properties I get a Jet Database Engine error: "External table is not in the expected format".

Everything else with the file appears the same (layout, formatting, etc.).

Any suggestions?

I have the same problem. Did you ever received suggestions or a solution. I would be happy to have the answer.

Thanks

No comments:

Post a Comment