hi,
i have a table with the name of contacts their fields are Emp Id ( Primary Key ), Name, Address, Mob No. of 100 contacts. i want to update existing table address and Mob no. of some employees whose not available by importing data from excel sheet. when i am importing data from excel to access previous data erased. so i want only blank cell will be update and existing cell will be remain same. For Example
Emp Id Name Address Mob No.
1 Nand Mango 9031757220
2 Rakesh 9031757221
3 Mahes Sonari 9031757222
4 Mukesh 98076788
5 Rakesh 9800007878
In above table i want to update Emp Id 2, 4 and 5 Address by Importing Excel Date without removing 1 & 3 address, Name and Mob No.
Thanks & Regards
Nand Kumar