Feel free to make a small donation to Influential Computers, Ltd for its efforts. Enter the amount you wish to donate below and you will be taken to Paypal for confirmation.
ExcelDBLinks is a Free Visual Basic Utility that enables the links between a database and Excel spreadsheet to be examined and then changed. The utility lists the databases associated with all embedded Queries and Pivot Tables within the Excel Workbook.
The functionality is as follows :-
Examine the MS Query Access Database links within an Excel Workbook, identifying all of the links within each Worksheet in the Workbook
Display details of the MS Query Access Database links
Change the database links individually or collectively
ExcelDBLinks is known to work in the following environments :-
Operating Systems
Excel Versions
Databases
Windows 9x, NT, 2000, XP
97, 2000, 2002, 2003
Microsoft Access 97, 2000, 2002, 2003
We believe that ExcelDBLinks should work in other environments too, so please feel free to Contact Us with your results.
The ExcelDBLinks utility is free to download and use. If you are having trouble using MS Query, please visit our MS Query Tips page.
The latest version of ExcelDBLinks is 2.0, released 16th May 2004.