Importing Text

[gselliott]

I am trying to Import a comma delimited text file into an existing table. I am trying to do this using VBA code but i am getting the following error: Field 'F1' doesnt exist in the destination table 'tblTest'
I have made sure there is the correct number of fields in the table and they are all set up as text fields. I have tried importing the same file using the wizard and it works ok.

Any ideas would be great!