check dates

[Sully38]

I am working in Access 2002

I have 3 .csv files that are coming in monthly, The task I am attempting to complete is to build a routine that will massage the data(Which I have already completed) The massaged data than need to get loaded into a large collection table.

Here is where I run into trouble on something I thought would be simplest aspect. The massaged data has a processed date on each record, All I need to do is check the Big File if that date exist let the massaged data write over the previous data.

My thought was to generate a maxdate query on the massaged data and run a delete query based on the large file with a criteria statement pointing to the max date:

DELETE [Big File].*, [Big File].FileDate
FROM [Big File], Query1
WHERE ((([Big File].FileDate)=[query1]![Maxoffiledate]));

Is there a better way than what I am trying to do ?

 

[SydneyGeek]

Maybe you could try building a simple query from the BigFile table to the Collection table, using the processed date as the join key -- unless I'm missing something, I don't see the reason for the MaxDate bit. Any matching records in BigFile can then be deleted.

Denis

 

[bat17]

It looks more like you want to use an update query to modify your existing data to match your new data.

HTH

Peter