Change ODBC

[PKL]

My colleague pulled data into Excel from an Access database on his desktop using an ODBC (user DSN with password). He recently left the company and the database was moved to a share drive. When I refreshed the data on Excel, I got an ODBC Fail error message. There are altogether 39 queries. How can I update the ODBC connections on that Excel file?

Thanks,

PKL

 

[Andrew Poulsom]

This may help you:

http://www.dicks-clicks.com/excel/ExternalData5.htm