Creation of A table

N

Nawel

Hello,
I have a report from a database which contain 11 activities (column header)
related to 283 sites with all the actual dates of each activity, I want to
import it to access to have the count of the records for each activity to
create a ressources planning based on that count. How can I do it , I don't
want to have a table with all the fields which are in the report and all the
sites.
Any help will be appreciated.
Nawel
 
N

Nawel

The report is made by a roll-+out tool for GSM networks, the report is an
excell file with the activities as columns and with sites as rows, every site
has or has date for each activity, I don't want to import it to access
because then I will have a table with 283 records (sites in excell) , what I
need is just the number of sites in each activity to know the actual number
of sites/activity to use it in soma calculation for the number of ressources,
I hope that you can help me
 
N

Nawel

hello,
It is not really what I need, It will just split my table into several
tables, waht I need is just the number of records for each activity to use it
in an other table to make calculations, because if I used the calculation in
this table when I make an export I had all the fields repeated 283 times.
What is the best way for that???
 
Top