import data

  • Thread starter Thread starter Dave B
  • Start date Start date
D

Dave B

I'm trying to import data from Excel to an Access table. Some of the
information is already in access, e.g. PersonID, Name, Address, etc. The
information in Excel is the phone numbers for entries that are already in
the table. Whenever I've imported before, it always creates new entries. I
have the PersonID in Excel too. How can I import the phone numbers to
records in the table that are already there and partially filled with info?
 
The *linked table* will always look to the data in Excel.

The UPDATE query will change/add the information to the PhoneNumber field in
your Access table.

If you add data to the Excel sheet, you can run the UPDATE query to update
the PhoneNumber field in your Access table.

P
 
Back
Top