Active Import External Data Wizard in VBA

  • Thread starter Thread starter Sidney Zhang
  • Start date Start date
S

Sidney Zhang

Hi:
Is there a way to active the "Import External Data" Wizard in Acess2003
using VBA?

Thanks a lot
Sidney
 
Hi Sidney,

Try
Docmd.RunCommand acCmdImport
.. But usually if you're writing code you'll need to exercise much more
control over what the user can do. The wizard lets a user import any
data whatever and give the new table any name they choose, which is
seldom appropriate in a database application.

If you post some more information about what you want to achieve someone
will probably be able to suggest a better way.
 
It works.
Thanks a lot John.

Sidney

John Nurick said:
Hi Sidney,

Try
Docmd.RunCommand acCmdImport
. But usually if you're writing code you'll need to exercise much more
control over what the user can do. The wizard lets a user import any
data whatever and give the new table any name they choose, which is
seldom appropriate in a database application.

If you post some more information about what you want to achieve someone
will probably be able to suggest a better way.
Click to expand...
 
Back
Top