DoCmd.RunCommand acCmdImport

[ryan.clair]

I was hoping to automate many of the options after the user selects
their .xls file via from the Form's side.

Perferably "Next" and then "Finish" (2001 Access)

 

[Rob Oldfield]

I'd suggest grabbing the name of the file by using

http://www.mvps.org/access/api/api0001.htm

and then using docmd.transferspreadsheet (with all the parameters set as you
require).

 

[ryan.clair]

Thank you! I saw that command before but hadn't thought of using that
bit of code before it.