'Search key not found' error while importing .csv file

[inso18]

Hello.

I need to be able to import .csv files into my database via VBA DoCmd.TransferText acImportDelim method. While most text tables do import well, importing one table, which doesn't look different from other tables, it has field names and values, gives the following error:

Run-time error '3709'
The search key was not found in any record.

I've deleted all the columns from that text table, leaving only one, which made it look like this:

Id
112233
112234
112235
....

still I get the same error.

Does anyone has experience with this?
appriciate your time,
inso18.

 

[inso18]

Well, I got the error worked out. I had 2 same column names in the text table.