Menu
Ask a question Report

Importing Excel Table

Posts
2
Registration date
Friday March 15, 2019
Status
Member
Last seen
March 15, 2019
 - - Latest reply: ac3mark
Posts
13034
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
 - Mar 16, 2019 at 02:38 PM
Office Software Ask a question Report
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

Report Respond to ac3mark
Posts
13034
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
 1537
0
Thank you
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.
Respond to ac3mark
Reply Ask a question