Importing Excel Table

Closed
rjnbiker
Posts
2
Registration date
Friday March 15, 2019
Status
Member
Last seen
March 15, 2019
- Mar 15, 2019 at 05:57 PM
 Blocked Profile - Mar 16, 2019 at 02:38 PM
How can I import a table from excel to acces and prevent creating duplicates in the access database if the record exists

1 reply

Blocked Profile
Mar 16, 2019 at 02:38 PM
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.
0