As some people may have noticed, comparisons between single tables in Access and Excel spread-sheets have been made several times, both on the Internet and in this blog. This might have even convinced a few people to recreate some of their spread-sheets in Access, luckily for them and Database Developers and Consultants, Microsoft has helpfully included the ability to import a variety of file formats into MS Access with only minimal configuring on the part of the user. This can save both regular people and developer’s lots of time as they or their clients’ needs may change to require a database rather than a spread sheet or similar file.
It’s really simple, just select the “External Data” tab in Microsoft Access, then select the “Excel” button and follow the prompts to import and configure your spread sheets into tables.
Importing Excel Spread-sheets to Access
Keep reading
More from the blog
Has your business outgrown Excel? Seven signs, and what to do about each one
Spreadsheets fail slowly, so nobody notices the day they stop being a tool and start being the system. Here are the signs, the fix...
What has changed in custom software development over the last 12 months
Software development continues to evolve quickly, but the last 12 months have seen some particularly significant changes in the wa...
How do you know which asset is about to fail before it does?
The failure was there in the data for three inspections before the breakdown. Nobody could see it because the data was spread acro...
Want to talk about your own project?
Tell us what's slowing your business down. One of our digital strategists will talk it through with you.