How does one merge several spreadsheets into a single Access table

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

Guest

I would like to merge several spreadsheets (each with several tabs) into a
single table.

I know that I have some duplicate records, so I would like for the query or
process to remove duplicates.

I think it would be great if this could be accomplished using Access,
because first, I read somewhere that it is easier to use Access for this kind
of thing and second, I read that Access was better for email merge processes,
which is what I'm eventually using this table for.

Any information and guidance would really be appreciated. I'm using Office
2003.

Thanks!
Mike C.
 
Click on FILE - Get External Data - Import and select your worksheet - import
in a new table.
Open the table in design view and set your primary key field(s).
Click on FILE - Get External Data - Import and select the next worksheet -
append in the table created above.
 
Back
Top