Creating an Import Wizard for .txt file

[JasAce]

Hi all

I'm wondering if on the off chance there is a way of grabbing the Access Import wizard and use inside VB? or a similar procedure?

I'm using an Access database, ADO, VB 6.0 SP3 and an MSFlexgrid. I would like to import a user selected ascii text file, allowing the user to select certain rows/cols/headers etc... so I can then re-arrange into the right format for my app (a basic cashflow). The info from the text file, would be exported out of the users existing app into my own.

Any ideas, or is it better to just create my own?

Thanks in advance...

[JasAce]

Any answers anyone???

[JHausmann]

You've (essentially) got two choices. 1) you can write your own routine and it will be able to run anywhere or 2) you can call Access from within your program and have it do the import which means your program will only run on machines that have Access installed.