How To Create An Access Database From Excel

How To Create An Access Database From Excel

To create an Access database from an Excel spreadsheet is simple enough to setup and apply. However, there are some preparations involved as data is being migrated from a ‘flat-file’ environment (which is what data in a spreadsheet provides) to a relational database (RDBMS – which is one of Microsoft Access’s strengths).

Take a look at this video tutorial to see some of the final steps in migrating and populating data to create an Access database from an Excel spreadsheet…

How To Create An Access Database From Excel

In this video which by the way is very well explained you need to have an existing database in place which means having relationships created and other objects. In fact, you do not have to have any objects in place as part of the import routines will generate new tables.

Have a plan, sketch out the data sets that will become separate tables in your Access database. Know you primary key fields (fields that will be responsible when joining tables together). Also know the data types as in the video it mentioned the contact number being stored as a number with an input mask. In some cases, it could be a text data type instead.

Creating an Access database will take some time and good planning and getting to know other important objects like queries too. In the video tutorial, it did mention the APPEND query!

create an access databaseTo learn more about Microsoft Access, check out my eBooks on how to create an Access database and in the meantime why not sign up for your
FREE copy of
how to import data into Microsoft Access.

One Reply to “How To Create An Access Database From Excel”

  1. In the video tutorial it mentioned the adding feature to group records to show as unique records when linking to the core tables (as lookups). You can infact also create DISTINCT queries to do the same which is a property setting in a normal SELECT query called ‘Unique Values’ set as ‘Yes’.

Leave a Reply

Your email address will not be published. Required fields are marked *