>I have encountered the following problem. I want to be able to import a comma-delimited file into an Microsoft Access database using Visual Basic and ADO. Has anyone had experience with this? I first want to confirm a text fiel exists and then import it.

Because you want to validate your data, you need to open the file, read it line by line, validate the code is existing and the insert into your Access table.

You can use this sample to start: http://www.freevbcode.com/ShowCode.Asp?ID=612