Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problems after installing office 2007

Status
Not open for further replies.

rogerte

Programmer
Nov 9, 2001
164
0
0
GB
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
 



Hi,

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

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top