Replace Table

[MattG]

I have an Access database with 1 table of about 6,000 records.
The table will need to be update once a day from a fixed-length ascii text
file containing all 6,000 records.
I would guess that no more than 10 records need to be updated/added per
day.

The daily update will be a scheduled script on the server.
The database is accessed for select statements by an ASP webpage.


What I think would be ideal would be to drop the table and just load up a
new one from the text file. But this means the table will be unavailable
for however long it takes to load in the text file.

The only other option I can think of is to go through the text file line
by line and compare it to the table to see if the record has been updated,
or if any new records need to be added. This means selects can still occur
while the table is being updated.

Does anyone have any suggestions on the best way for me to do this?

Thanks,
Matt

 

[REM7600]

Import text file to a temp table and then do your update from there? Remove
the temp table when finished?

REM7600