Convert Excel Table to Access Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to recreate the Excel table below in Access for a number of
reasons. I need help in creating the form/report so that it shows with lines
around and under each catagory. Also gives me totals in the appropriate place.


SC2x Rel 3.x
08/06/07 08/06/07
SC2x Rel 3.x Severity Total Numbers SC2x Rel 3.x Priority Total Numbers
Critical 36 1 8
High 52 2 71
Medium 11 3 7
Low 2 Unassigned 15
Total 101 Total 101
 
Repeat after me ... "Access is a relational database, Excel is a
spreadsheet."

If you try to feed Access 'sheet data without normalizing it, you will not
get much benefit from Access' relationally-oriented features/functions.

If "well-normalized" and "relational" are not part of your
experience/vocabulary, plan on a bit of a steep learning curve, as you need
to get the data right first before you can move on to Access forms and
reports.

If you'd care to share your "number of reasons", the folks who frequent this
newsgroup may be able to offer alternate approaches.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top