Importing .xls via Forms view

[ryan.clair]

What I'm trying to do:

Import a .xls file from the Form's view (end-user) and use the .xls
file to run queries/reports on.

I was thinking of using a command button... importing the .xls file and
perhaps copying it into a local table so that I could run all the
queries/reports to my hearts desire.

I know how to do this from an Administrator view but I want this to be
done from a restricted user... preferably one button that opens an
"Open" window and the user picks the .xls file.

Please let me know if that makes sense or if it can even be done.

Thanks,

 

[ryan.clair]

Sorry I forgot to mention....

I know of the DoCmd.RunCommand acCmdImport command but I want all the
options to be defaulted yes and the name of the "new table" a specific
name....

Think of the user as really really computer illiterate- I'd hate for
him/her to mess up somewhere.

Thanks again!