Visual Basic CUSTOM Importing...

[Anthony & Jennifer Vitale]

I am converting an access application to VB4.0. I need to have the
ability to perform a CUSTOM IMPORT/EXPORT (as in Access) to allow
for different types of files to be loaded into the ACCESS Tables.
I know VB Supports TEXT import (Delimited...), Access, Dbase,
Foxpro etc. But what is not known is how to import a FIXED width
Flat, Lotus 123, Excell file.

I would like to be able to access the MSAIN200.DLL (the DLL used to
import/Export files in access) by Declaring the sub/function with
the proper parameters and let the DLL continue the process. I am
trying to stay away from the need to Have Access or the Runtime
Version of Access on the PCs.

I know I can use OLE or DDE (I have done this successfully) but in
both cases I need to either have ACCESS on the for OLE or Running
in the background for DDE.

Basically, how can I write a VB application which allows the
importing and exporting of Data from one type to another as in
ACCESS "CUSTOM IMPORT/EXPORT"?

Any Assistance will be Welcomed...

Thanks, Tony
Anthony & jennifer Vitale