I am trying to open using the DTS excel connection (SQL 2000) an excel
document with 20 tabs and n number of macros. That tab that I will be pushing
data into, does not have a macro. But when I try to assign the excel document
to the Excel Connection object, it return the following error:
Microsoft Jet Database Engine
External Table is not in expected format
What does this mean??
I can open using th above method other excel documents and push the data
into the tab, so long that there is no macro...
Sometimes error messages aren't all that meaningful or relevant. Have
you tried posting this question in one of the Excel newsgroups?
Perhaps someone there will have more experience with this situation.
On Tue, 29 May 2007 11:26:01 -0700, Tomas