Import file using switchboard

[KciR]

Guys & Gals, need help in importing excel file using switchboard. thanks a
lot.

 

[Ken Snell [MVP]]

More details, please. Are you hardcoding the name of the EXCEL file and its
location? Are you wanting to select the file to be imported?

See this page for various examples of VBA code for importing EXCEL files:
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm

 

[KciR]

Thanks, Ken, I'll try out your suggestions.
I am going on vacation, What I am trying to do is instead of explaining to
the user of my database the importing process of excel file to access, i just
want them to click on a button from the switchboard and everything will be
done for them.