Hi.
I am looking to upload Excel file into MS access table but i want to upload only new recrods i.e (already existing records not upload).
Thanks,
Nikh
Hi.
I am looking to upload Excel file into MS access table but i want to upload only new recrods i.e (already existing records not upload).
Thanks,
Nikh
if you have a primary key in your table and it exists in your excel file then it won't be imported since duplicates are not allowed
Or else you can make it a 2-step process: first import the entire file and then run an unmatched/append query.
I dont have primary key in table then how can i upload file and only import new records into access table using vba code....
is there any code you have ..pls provide me..
Thanks,
Nitesh
Use the query wizard for unmatched, then change it into an append query.