[RESOLVED] Get External Data

[Pierre]

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

[Clunietp]

Why not just open the CSV and access DB, read in the CSV line by line, parse the fields, and insert a new record into your database?

[peet]

try this link: http://www.vbforums.com/showthread.php?s=&threadid=100935

might give u a tip on how to do what Clunietp suggested