Problems after installing office 2007

[rogerte]

Company has just centrally, updated all PCs from Office 2003 to Office 2007 (Word/Powerpoint/Excel).

This has caused a problem for a few PCs that have a VB6 program on them that creates Excel files via ODBC - and of course these are important files!

Now they get an "External table is not in the expected format" error during export.

I am not a VB programmer, but have found the old code and it has a connection string of:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & TheFile & ";Extended Properties=Excel 8.0;"

(where TheFile =Excel).

I assume that loading Office 2007 has changed the ODBC drivers.

Which would be the best way to get over this problem?

Many thanks

 

[SkipVought]

Hi,

I don't know offhand. But you'll get a much better response if you post your question in forum707.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]