I am trying to export a table into a txt file, tab delim. I have the export spec built. When I run the code below, the existing data from the destination file gets inserted into the table. In other words, it's running completely backwards:
Private Sub cmdGetInventoryData_Click()
txtExportName = "C:\AmazonFeeds\data.txt"
DoCmd.TransferText acExportDelimited, "AmazonInventoryCreateData", "Data2", txtExportName