Many of you are aware of my previous article about linking to Excel spreadsheets
Advanced SQL To Connect With Excel WorkBooks
My previous article explored using plain SQL to connect and work with other Access databases: This time, I thought I’d show you how you can create SELECT statements that can bind directly to an Excel Workbook to work with the data without the need of Linked Table or advanced VBA coding.
In the section entitled ‘A Workaround For Linked Tables’ I provided some VBA code to change the necessary connection property.
Knowing that not everyone is comfortable with VBA, I decided to quickly put together a simple form that you can import directly into any database and use it to configure the connection property for you so you don’t need to know a thing about VBA!
It’s a simple import and use solution.
Disclaimer/Notes:
If you do not have Microsoft Access, simply download and install the freely available runtime version (this permits running MS Access databases, but not modifying their design):Microsoft Access 2010 Runtime
Microsoft Access 2013 Runtime
Microsoft Access 2016 Runtime
Microsoft 365 Access Runtime
All code samples, download samples, links, ... on this site are provided 'AS IS'.
In no event will Devhut.net or CARDA Consultants Inc. be liable to the client/end-user or any third party for any damages, including any lost profits, lost savings or other incidental, consequential or special damages arising out of the operation of or inability to operate the software which CARDA Consultants Inc. has provided, even if CARDA Consultants Inc. has been advised of the possibility of such damages.
In no event will Devhut.net or CARDA Consultants Inc. be liable to the client/end-user or any third party for any damages, including any lost profits, lost savings or other incidental, consequential or special damages arising out of the operation of or inability to operate the software which CARDA Consultants Inc. has provided, even if CARDA Consultants Inc. has been advised of the possibility of such damages.
Download a Demo Database
Feel free to download a 100% unlocked demo copy by using the link provided below:
Download “Excel Linked Table Connection Fixer” ExcelConnectionFixer_V1.000.zip – Downloaded 4279 times – 45.65 KBVersion History
| Version | Date | Changes |
|---|---|---|
| V1.000 | 2022-03-01 | Initial Release |