Looking for a VB 5 import Tool...

[syscrash]

I am looking for a VB 5 tool that will allow me to import text files
into Access 97. Does anyone have anything like that or know of anything?
I would rather not use the Access Import wizard API because it has too
many options.

Thanks in advance for any help you can give.

 

[strongm]

Microsoft have already provided a pretty comprehensive example of various methods that can be used from VB. Rather than duplicate their efforts I'll provide the link:

http://support.microsoft.com/kb/230265

 

[syscrash]

Thanks strongm, I found that same KB a few hours after I posted this and so far it is exactly what we needed.