Change Database Links In Excel Workbooks

Do you have Excel97 workbooks with queries and/or pivot tables linked to Access97 databases?

If you need to point the queries/pivot tables at a different database, you have moved the original database, or you have moved the workbook, you will need to change the embedded links.

To perform the task easily, please visit our site at www.ExcelDBLinks.com and download the free Visual Basic utility.

The routine uses DSN-less connections. It will replace DSN connections with DSN-less connections, and change existing DSN-less connections to point to a new selected location.