Conditional import from excel

[Guest]

Hi,
While importing data from an excel sheet to access, i need to set up a
condition during the import.
The condition should work like this: While importing from excel, if the line
in excel already exists in the database, then only one field from this line
needs to be imported or rather updated in the existing line in the database.
Is this possible.
For eg: While importing employee information, if the employee record already
exists in the database, then only the employee status must be updated from
the excel sheet to the existing record in the database.
Any help will be much appreciated.

Sashi

 

[Ken Snell \(MVP\)]

Easiest thing to do is to import the EXCEL data to a temporary /
intermediate table. Then use an update query to change the data of the one
field when the record already exists in your permanent table. This will give
you complete control over the process, and won't require you to write
complicated code/programming to do the conditional import.