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?
Excel Facts
What do {} around a formula in the formula bar mean?
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.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
