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

Importing Excel Table
How to screenshot excel table - Guide
How to import excel data to another excel sheet - Guide
Insert rows on change of value in Excel table ✓ - Forum - Excel
Import excel data into mysql database ✓ - Forum - Excel
Excel table unique id ✓ - Forum - Excel

1 reply

Answer 1 / 1

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.

Subscribe To Our Newsletter!