Previous Topic Next Topic

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
Related:

1 response

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.

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

Hello,

I have got dates typed in the format following 01.08.98 and I want to change it to 01/08/1998 format. I tried applying the format we have in excel format cell date format but nothing is happening.

Please help me on this.

11 responses