Import Excel DB into Access

[peast3]

I am not familiar with the import function. I would like to move our entire Excel DB into Access to make things faster. How can I export Excel into Access and keep formatting, equations?

 

[alansidman]

You will need to ensure that your tables are normalized. You can then use the wizard to import them or you can link them directly. As to your formulas, they will have to be, in all liklihood, converted to Queries. Formatting is something that only applies to Reports. If you are new to Access, then here are two links that you should read and understand before jumping into this project.

https://forums.aspfree.com/microsoft-access-help-18/relational-database-principles-208217.html
Fundamentals of Relational Database Design -- r937.com