Create Databases With Excel
Post date: Jun 23, 2016 1:30:24 AM
I recently needed an MS Access database but my work PC doesn't have MS Access on it. No problems. I have Excel plus VBA and SQL skills. Putting them to use I developed an XL app to create MS Access databases. You can get a copy from the link below.
This app works great for my purposes.
It creates MS Access files (the database)
It facilitates defining and creating DB tables
It imports definitions from existing DB tables
It facilitates altering existing DB tables
It exports records from XL to DB tables
It imports records from DB tables to XL
It clears all records from DB tables
It can even drop/delete DB tables entirely.
Those who have and love MS Access won't want this. It's not as good. But it's good enough if all you need is a simple database to support an XL app.
Those wanting to learn more about databases and how to integrate them with XL may find this a great learning tool.
Like all BXL apps, the app is free and the code is unprotected. It also comes with documentation which you download first. It provides the link to the XL app.
