ExcelBanter - Changing ODBC link in a query

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Changing ODBC link in a query (https://www.excelbanter.com/excel-discussion-misc-queries/146321-changing-odbc-link-query.html)

Keith

Changing ODBC link in a query

I have a spreadsheet that pulls data from an ODBC link. This all works great.
However I now need to change which ODBC it uses. I know it can be done, as I
have done it once before, but I can't find my notes on how to do it.

Can anybody help?

All times are GMT +1. The time now is 12:37 PM.