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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADO calls

Status
Not open for further replies.

Trudye

Programmer
Sep 4, 2001
932
US
I am learning Excel VBA, ADO calls. I am blowing up on this command:
.Provider = "microsoft.jet.oledb.4.0"

The book I am using says that may not be the correct version for my machine, but does not explain where to get the correct version number. Does anyone happen to know where this information resides?

I looked in Excel;Help;System Information but did not find any reference to the JET version.

Thanks
Trudye
 
Oops, actually I found one relavent reference:
msjetoledb40.dll

Which would lead one to believe that my version number is correct. Except I have two versions of Office loaded 97/2k.

Thanks again
Trudye
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top