Importing data but not appending the file and not losing relations

[smiller600]

i have a data table that i've established relationships to in a query. i
want to be able to re-import data into the table and have the table be
overwritten with the new data without loosing the relationships. also, the
date from the table is in the format of yyymmdd and i can not seem to find a
way to get access to convert to a date properly

 

[Engin]

What you're describing looks like it would need an update query to replace
the required fields.
The date problem should be resolved usþing the Format function.

Good Luck,

Engin