Automating Access Import Wizard

[Guest]

How can I call and/or use the Access Import Wizard from a VBA module?

I'm working in Access 2007 and I've searched Google and the MSDN reference
for Access 2007 and haven't found anything.

I appreciate any advice or help you can give me.

Thanks...
J--

 

[Steve]

Look at the TransferDatabase method in the Help file. Also check out
Transferspreadsheet and TransferText.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Guest]

I appreciate the response!

I am familiar with the normal VBA methods for importing data. What I'm
trying to do is create a wizard that makes importing delimited data even
easier than the Access wizard. I like the way that the wizard generates the
preview and I'd like to emulate it in my own wizard.

As a complete aside it works very nicely and I'd like to understand how they
coded it.

I'm looking for documentation on the wizard or a method to automate the
wizard.

Thanks for all you help!

J--