Importing an Excel file in to Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm trying to automate importing an excel template file in to an Access table.
I'm using DoCmd.TransferSpreadsheet and it works fine.

Only problem is that you have to state the full path of the excel file to be
imported.
I'm using an input box for the user to type this path in - but this is a bit
clunky.
Can someone tell me how to bring up the file import menu to allow the user
to select which file he wants to import more easily.

I can acheive this as well, but the user then has to go through the Access
"get external data" menu system - which I don't want to do

any help appreciated....Rgds Chris
 
Back
Top