Import File Dialog Box

[John G]

How would I get the Import File Dialog Box to open (this
is the dialog box in which you choose the file you want to
import, then the import wizard shows up) when a command
button is clicked (in other words, what is the code that
will automatically bring up this dialog box)?

 

[Allen Browne]

Best way is the code in this link:
http://www.mvps.org/access/api/api0001.htm

If you are using Access 2002, you can use the FileDialog object instead.
However, this requires a reference to the Office library, doesn't work with
SaveAs (even though it offers the option), and doesn't work in an MDE or
runtime version, so the API call is infinitely better.

 

[Allen Browne]

Best way is the code in this link:
http://www.mvps.org/access/api/api0001.htm

If you are using Access 2002, you can use the FileDialog object instead.
However, this requires a reference to the Office library, doesn't work with
SaveAs (even though it offers the option), and doesn't work in an MDE or
runtime version, so the API call is infinitely better.