Transfer Text Action

[StephenD]

Hi,

I'm currently setting up a database that every month will import a txt file of around 1 million records-I think I'll be using the transfer text method. However, this appends records to existing tables-I want to first empty or clear the existing table to overwrite with the current data. Can this be done in one procedure?

Also can you get a message to come up saying 'import complete' or something similar?

Thanks!

 

[BukHix]

You can use a delete query to remove the table just before you recreate it. Then you would do a msgbox("Transfer Complete") or something similar to that to notify the user.