Updating odd fields in existing records from Excel (1 Viewer)

[chris01252]

I currently have a database that is missing various pieces of information, we are getting a temp in to complete this. I don't want the temp adding data directly into Access so I have exported the table that needs updating into Excel.

How can I then import the new data without altering current data.

I know this is no problem for new records, but if I have a current record with a few fields of information missing how can I just import information into the blank fields. This can't be a manual process as there are hundreds of records.

Any comments would be much appreciated!

Chris

 

[DJkarl]

Import the file into a new table then use an update query to update existing records. You can then append the new records using an append query.