importing many text files one at a time to a access 97 table

[Ted Johnson]

Microsoft support staff,

I am having problems trying to understand, develop a
process that would convert many text files in to an Access
97 Table format.

For example:

I have four text files (1.txt, 2.txt, 3.txt and 4.txt).

Then, I would like to be able to open Access MDB, and run
some type of macro, and then convert the 4 text files to
Access Table format (tbl1, tbl2, tbl3, and tbl4). When
reaching the last Text file (EOF), then stopping the
conversion function process.

End Macro

I have the process of what I want to do, but for some
unknown reason, I can not figure out what type of VB
commands to use to make the process work.

If you could guide me in the right direction, I would be a
grateful man.

Thank you,

Ted Johnson