Transfering from Excel to Access

[robertdseals]

I have an Excel database (several linked workbooks) that is getting way too big and cumbersome. I've been thinking about transfering it over to MS Access, but I fear that might me a major endevour. Any suggestions?

 

[Joe4]

I have an Excel database (several linked workbooks) that is getting way too big and cumbersome. I've been thinking about transfering it over to MS Access, but I fear that might me a major endevour. Any suggestions?

It probably will be a big endevour, but should be done anyway!
It will probably be a lot of work up front, but work much better and save you lots of time and hassle down the road.

Just be sure to create a well-designed Relational Database that is normalized! If you don't follow at least the first few rules of normalization, it will make the data very tough to work with.

There are lots of good article and tutorials to assist on those things that can be found with Google searches.
Here are a few to get you started:

Database normalization description - Microsoft 365 Apps

Describe the method to normalize the database and gives several alternatives to normalize forms. You need to master the database principles to understand them or you can follow the steps listed in the article.

docs.microsoft.com

Database design basics - Microsoft Support

support.microsoft.com

 

[Micron]

Access has 2 learning curves IMO. One is short and uses all the things you should never do. The other is much longer, but how long depends on your ability to implement what you find/learn and the complexity of the project and its needs. Here's my whole Enchilada of links, and I agree that understanding and implementing normalization is very important. Perhaps the best thing is, Access will allow multiple concurrent users.

Normalization Parts I, II, III, IV, and V

What Is Normalization, Part I

Thoughts, opinions, samples, tips, and tricks about Microsoft Access

rogersaccessblog.blogspot.com

and/or

Database Normalization – Holowczak.com Tutorials

holowczak.com

Entity-Relationship Diagramming: Part I, II, III and IV

Entity-Relationship Diagramming: Part I

Thoughts, opinions, samples, tips, and tricks about Microsoft Access

rogersaccessblog.blogspot.com

How do I Create an Application in Microsoft Access?

How do I Create an Application in Microsoft Access?

Thoughts, opinions, samples, tips, and tricks about Microsoft Access

rogersaccessblog.blogspot.com

Important for success:
Naming conventions - General: Commonly used naming conventions

MS Access Naming Conventions

_________________________________________________________ Naming Conventions. This document is aimed at the user who is unfamiliar with any naming convention. It is based upon personal experience and the interaction I have had with others. It is not a hard and fast rule. Why use a...

www.access-programmers.co.uk

What not to use in names
- Microsoft Access tips: Problem names and reserved words in Access

About Auto Numbers
- UtterAccess.com
- General: Use Autonumbers properly

The evils of lookup fields - The Access Web - The Evils of Lookup Fields in Tables
Table and PK design tips - Microsoft Access Tables, Primary Key Tips and Techniques
About calculated table fields - Microsoft Access tips: Calculated Fields
About Multi Value Fields - Multivalued Fields - Mendip Data Systems