TransferText

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

im using the folowing code in an Access 2003 database

DoCmd.TransferText acImportDelim, , "DCS_DATA_Specification",
"T:\DCS_Data\viewer\DCS_DATA_Easington.txt", False


the code works fine but when the code executes it creates a new record in
the table. how do i get it to over write the existing table so only one
record only ever exists
 
Delete the data from the table first using a delete query:

DoCmd.RunSQL "DELETE * FROM DCS_DATA_Specification"
 
Back
Top