• Welcome to Tux Reports: Where Penguins Fly. We hope you find the topics varied, interesting, and worthy of your time. Please become a member and join in the discussions.

How to update ODBC connection properties in Excel



Flightless Bird
Just working on testing a migration from SQL 2000 to SQL 2008. I have an
Excel 2003 document with macros - when I open the document, I get Microsoft
SQL Server Login failed.

I'm trying to update the connection properties for the database/username,
but I can't find out where it's trying to connect. I combed through the VB
macros and I can't seem to find it anywhere.

So where can the information be modified so I can make sure it's pointing
and authenticating to the new server?