Sending data to a Access database

[kanejone]

I have a few thousand files that are all in the same format. I need to know how to connect to a database to send all the information within these files (*.txt) up to my database. I have set up the database with all the relavent fields and have set up the parsing of the text file. Can someone please tell me how to send that data up to the database.

Thanks a lot
JK

[paulw]

Use the Dir function to retrieve the filenames in a given directory and then parse them individually. Presumably you know about Open, Input, Get etc.?

If not, post back and I'll drop some code off.

P.

[kanejone]

Thanks a lot fot the reply. I would really appreciate a little bit of code as an example to work off. I'm a little bit rusty on the VB at the moment!!!!!!

Thanks again
JK