Expert: Geoff - 6/11/2009

Question
I am new to this.and im doing my internship in an info management dept.i was given a task to convert a current database using excel 2007 to access 2007.I know how to import and link. but the the data in excel use so many formulas and a lot of data.My question is :
1. How do we convert excel data with formula to access
2. There are a lot of sheet in an excel file,should I divide them into several table?

Answer
Shafinaz, hi

1. Normalise the raw Excel data into individual Access tables (see wikipedia about Normalisation if you are unsure)

2. Leave calculated cells out of this process - only 'raw data'

3. Calculations go into queries. A query builds on raw data held in tables, does the set of calculations and 'presents' the results. Queries may be hierarchical in structure. So you can build up a result in several steps.

4. Build reports for management based on one or more final queries. Reports may be nested, so you can have a master report with one or more nested sub reports containd therein. The report is what you save to PDF (for example) and is what is presented to management.

I hope this helps

Kind regards

Geoff :-)