Access 2000 help needed.

[yugpatel]

I am working on project that requires reading of all files in a particular directory and then append database.
How would I do that? Each file has information that is space delimited that is to appended into database.

Directory format:
C:\FOO
A1.txt
A2.txt
A3.txt
.
.
.
.


Each of .txt format:
011603400026 00:00:00:00:00:1A 00:00:00:00:00:E2

Note: Each file name is unique and information in each is unique.

Please help.

 

[yugpatel]

Does anyone know how to do this?

 

[MrChad]

Are you familiar with Visual Basic? You could probably write a small VBA app to do this. There is some good documentation on MSDN.

 

[yugpatel]

Thanks for your reply. I did little VB programming but not a whole lot. I will check out that site.