I have an instrument that generates a comma delineated text file. This file needs to be appended to a table in a database. I can do this on a whiff using access, get external data controls but I cannot seem to do this with Visual Basic 6.0. How does one get external data to append to the bottom of an existing table? Currently I am using ADO and I can see both text and table files but I cannot seem to join them together. Any suggestions?

Database: Access 2000
Text file: Comma Delineated

Thanks

Pierre