Import spreadsheet button

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

Guest

Hello,
I'd like to add a button to the switchboard that'll import an Excel
spreadsheet. The imported spreadsheet which will update an existing table.
Let's name the spreadsheet "test" and the table "test". Both Excel and
Access will be the only two files in the folder.

Thanks in advance for your help.

Ellen
 
Hello,
I'd like to add a button to the switchboard that'll import an Excel
spreadsheet. The imported spreadsheet which will update an existing table.
Let's name the spreadsheet "test" and the table "test". Both Excel and
Access will be the only two files in the folder.

Thanks in advance for your help.

Ellen
Click to expand...

You can use the TransferSpreadsheet method.
Look it up in VBA help and set each argument appropriately.
 
Back
Top