Excel DB Links

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 SystemsExcel VersionsDatabases
Windows 9x, NT, 2000, XP97, 2000, 2002, 2003Microsoft 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.

Please Note: Because your browser doesn't support JavaScript (or you have disabled it), you will not be able to view this site as it is intended, and some functionality will not be available.

 

This Free Visual Basic Utility is the result of a joint development initiative between Influential Computers and Axsis Consultants.

Page last updated 28/04/2015 16:02:30      Copyright © 2003 Influential Computers Ltd. and Polly Projects All Rights Reserved