Want TransferText Action to overwrite old data

[cindyb]

When I transfer a text file to my database, I want
TransferText to overwrite the existing data in a table,
not to append. I don't want to delete the table object and
then do a TransferText. Is there a way to tell
TransferText to overwrite data?
Many Thanks.

 

[John Nurick]

Hi Cindy,

You can't make TransferText overwrite the data. Instead, create a Delete
query that zaps the existing records in the table. Then have your macro
run the query before it calls TransferText.