Menu

Importing Excel Table

Report
Posts
2
Registration date
Friday March 15, 2019
Status
Member
Last seen
March 15, 2019
 -
ac3mark
Posts
13029
Registration date
Monday June 3, 2013
Status
Member
Last seen
October 11, 2019
 -
How can I import a table from excel to acces and prevent creating duplicates in the access database if the record exists
See more

1 reply

Answer 1 / 1
Posts
13029
Registration date
Monday June 3, 2013
Status
Member
Last seen
October 11, 2019
 1,643
Use the excel sheet as an external data source, link it to a table in access. The table should already have a key colum that will not allow duplicates. That simple.
Reply Ask a question