Change Connection to Database

[sereleg]

Hi all
I have an Excell document that brings data from SQL server using an Store procedure. This Excell document is reading an old database so I need to update the data source by changing the old database name with a new one. I would like to create a new EXCELL but this is a very sofisticated excell and I am looking the short way to do this change.


I will appreciate some help on this.

Thanks

 

[fredericofonseca]

How it Excel doing that? Is it using MSQuery, or is it using ADO/DAO/RDO?

Either way you just need to change the server name on the connection string, either within the code or on the ODBC DSN admin depending on how it's defined.

A lot more info is needed to be more precise.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com