import excel data to existing table

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

Guest

New to access and need help.

I have an existing table with customer info with about 50 fields.
I routinely get an excel sheet which contains a customer name plus 11 of the
fields.
(One or two customers at a time)
How can I import the 11fields to the specific customer data in my table?
 
Are these all new customers? If they are, it will be easy, If not, it will
be a bit more work. I am assuming they will be new.

So, I would start by creating a table in Access that has the 11 fields in
it with the data types that you need defined. We will call it the Tranfer
TableThen, whether you use a macro or VBA, here are the steps:
Delete all the data in the Transfer Table
Import your spreadsheet into the Transfer Table
Use an Append query to read the data in the Transfer Table and add it to
your Customer table.
 
Back
Top