I have an excel file (only 2 pages) containing formulas for calculations from input of data. I like to make an access database out of it, so that it can be viewed and used in a more efficiant way with reports etc.. But, I have no idea how to do this.
In a databse such as access it is a more userfriendly layout which I like to achieve. Can somebody help me? I can send the excel file as attachment if somebody likes to help me. This is probalby very easy for anyone who knows access or similar programs.....
To use your excel workbook in Access all you have to do is Link the workbook to Access.
To Do this
Open Access Database choose get external data Link Tables choose files of type Microsoft Excel and follow the wizard through to completion
You will need to do a similar Link for each Excel Sheet.
Your Excel Sheets can now be used as database tables