Want TransferText Action to overwrite old data

  • Thread starter Thread starter cindyb
  • Start date Start date
C

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.
 
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.
 
Back
Top