Folks,

I'm able to imprt from a database using an SQL ODBC connection into EXCEL97 but I am not able to import using the same connection and EXCEL2002. I've lowered the MACRO security to low.

Any ideas? What would have changed in EXCEL2002?

TIA,

Jim

What exactly happens?

I know that there were changes from 97 to 2000/XP that affect several areas. I had to rewrite a few macros because of the Object Library changing. The change here is that 97 used DAO, while 2000/XP use ADO.

Do you have the ODBC add-in?

http://www.microsoft.com/downloads/d...displaylang=en

Was the Excel upgrade the only change? Did you upgrade Operating System to XP? Have you gotten a new PC? Are you using MSQuery to import into Excel? I have upgraded Excel a couple times with few problems in my OBDC connections.
But an OS upgrade (especially to XP) can be a different story. In Windows XP if you don't have Administrator Privileges, that can set off a bunch of problems. Took me @ a week to resolve all the issues.