Import external table

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

Guest

Hi,

I have a table in access. I want to import data from an excel spreadsheet
into the table in access. So I go to get external data and import.

The problem is that I want to replace the table in access - the table is
just appended to the access table.

Do I have to delete the table and reimport everything?

Thanks for your help
 
Jeff,

It must be me but I do not get your question totally. Do you import the
excel spreadsheet into an existing table or do you import it into a new table?

After that can you tell a little more specific what you want to replace? Do
you want to create your own table and add the records from the imported table
to that table. You can do that by just using an append query and then delete
the imported table.
 
Back
Top