I have an csv file which looks like this:

1,243,243hrzn',03/04/2003'
2,244,244brst','01/15/2001'
3,42,42Ortho',03/01/2003'
4,70,70slvy','01/15/2001'
and I want to put those into a table (tblTempMasterDates) usin the TransferText Command. The only problem is that the command is looking for the field F1, F2, F3, and F4.
Is there any way that I can just put the data into the fields that are already in the DB?

Code:
DoCmd.TransferText acImportDelim, "", "tblTempMasterDates", "C:\Progra~1\VIH\return.csv", False

thanks

Dimava