when importing data from excel to access existing tables

D

D Henderson

I am wondering if there is a way to have an existing table in access with
records in it that I want the importing data to look at and import any data
not in my tables without duplicating the data already in my access tables?
(Example: if I have a name SSN and a blank column, I want it to look at the
SSN and fill in the blank column with the data from excel) This is a process
I wish to do every month, and I am trying to eliminate having two tables in
access with virtually the same data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top