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
11979
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
April 22, 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 

Your reply

Reply to this topic

1 reply

Report Respond to ac3mark
Posts
11979
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
April 22, 2019
 2481
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

Your reply

Reply to this topic
Ask a question