How do point to a different SQL Database

[frenzting]

Hi all, I'm new here and have little background in programming. I desperately need help on SQL Query.

Currently, my company is upgrading from SQL 7 to SQL 2000. A lot of our excel files use SQL query to access the database. How to repoint the SQL to the new database?

Thanks so much.

[MAK]

If I am you, on a weekend I will rename the current 7.0 server to something else. bring the new SQL Server 2000 as the old server name. Restore all the database in the new server.

So you dont have to change anything in Excel.

[frenzting]

Thanks. but i think my situation is a bit troublesome. Hope you can really help me.

Currently my excel files is reside in the old server pointing to the old database. I have a new server with the duplicate database. I change the ODBC in the old server to point to the new server and when I switch off the old server SQL service manager, the excel files can't be refreshed. Is the excel file now pointing to the new server when I change the ODBC?

[Rawhide]

If it was changed correctly, it should be pointing to the new server.

[frenzting]

I do it as accordingly but the query still point to the old server. pls help!!!!