Error: Duplicate Output Destination

This is the code that I am using:
Private Sub Command6_Click()
DoCmd.TransferText acImportDelim, "", "CustomerAlignment", "E:\MonthlyAlign.csv", True
End Sub

However, I'm getting the error Duplicate Output Destination for a field that appears twice within the CSV file. I need to retain this field, but I do not know how to get around this error.

When I manually import the file with the Import Wizard there isn't a problem, just when I import the file with VBA.

Thanks in advance,
Paul

I believe your problem is in your csv 1st row. You might have two columns with the same name as one of the fields in your access table. Try renaming the 1st row names in the csv file to match your Access table field names exactly and then run your code.

lwells