Import data from excel to Access Database

[n2d2cool]

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

[CJ_London]

1. create a linked table to your excel file
2. then use an update query based on the 'find unmatched query wizard' to update your table