multi-import

  • Thread starter Thread starter skc
  • Start date Start date
S

skc

I have around 30 spreadsheets in MS Excel.

I want to import each one as a separate table (which is
easy by just going to File>Import), then I want to import
each one into another table which contains the amalgamated
entries - so each table appended to the bottom of the
table.

The spreadsheets just have 3 columns and can contain
duplicates:

Make: e.g. Ford
Year: e.g. 2003
CC: e.g. 1994

Please can someone advise on how to do the above.

Thanks,

skc
 
skc,

You can create an append query and add the info from the
30 tables into a master table.

John Parkinson
 
how - can you assist me???
-----Original Message-----
skc,

You can create an append query and add the info from the
30 tables into a master table.

John Parkinson

.
Click to expand...
 
SKC,

After you have imported all of your excel files.
(tblCars1, tblCars2, tblCars3 etc)

Go to 'Querys'

then 'Create Query in Design View'

Click on your first table (Example: tblCars1) and
click 'ADD'. Add all of the field names to the query by
double clicking the blue title bar and dragging the fields
into the query.

There is a RED Exclamation point on the toolbar, choose
the icon to the left and click 'Make Table Query' and type
a name in the space provided, example tblMasterCars. Click
the Red Exclamation ppoint to run the query.

At this point there are zero records in the tblMastCars
table. Click again to the left of the Exclamation point
and choose 'Append Query' then type the destination file
name(tblMastCars).

Again click the exclamation point to run the append query,
you will be asked if this is the operation you want to
perform. Click 'Yes'.

Now create another append query and repeat until finished.

John

Sorry if I left anything out, phones ringing like crazy
right now.
 
Back
Top