Is this easy to do

B

Baha

Using Access 2003, is this easy to do:

I have an excel sheet of about 1000 columns of about 100
fields each. I also have 20 smaller excel sheet of about
15 columns each with exactly the same field lay out as the
larger data base. I need to

1) Import and merge the smaller databases into the large
one without messing up the content of either of them.
THEN
2) Compare the averages data in some of the fields of the
smaller sheets to the averages in the same data elements
in larger data base.

I will need to do this on frequent bases generating some
reports.


I am an average user who is technically challenged, Is
this easy to do with Access?

Any pointers to good examples. What is the best book to
help me learn Access?


Thanks
 
S

SJ

Hi there,
Have you tried "linking" the spreadsheets as tables, then creating and
running your queries. By the way, a column and field are the same thing
really, I presume you mean 1000 ROWS.
Rows are horizontal and column/fields are vertical.

Yes, I think I would link the spreadsheets as tables and then create a
HOLDING table in access and create some append queries.
Append the spreadsheet data to the HOLDING table, then use the HOLDING table
to run your reports from. In this way the spreadsheets will not be altered.
To create the HOLDING table ,, IMPORT a spreadsheet then delete the data.

..
 
S

SJ

one other thing, if you link the tables and import data on a regular basis
the MDB will get very big quickly, you will need to COMPACT it on a regular
basis.
 
M

Mike Painter

Baha said:
Using Access 2003, is this easy to do:

I have an excel sheet of about 1000 columns of about 100
fields each. I also have 20 smaller excel sheet of about
15 columns each with exactly the same field lay out as the
larger data base. I need to

1) Import and merge the smaller databases into the large
one without messing up the content of either of them.
THEN
2) Compare the averages data in some of the fields of the
smaller sheets to the averages in the same data elements
in larger data base.

I will need to do this on frequent bases generating some
reports.
Click to expand...

I would say this is better done in Excel. Certainly the averages are. If
each of the smaller sheets are separate files, import or cut and paste them
onto separate pages of Excel and work with that.

Without knowing if the reports are very complex I would guess you could
simply set up another Excel page to show your results.
 
Top