Import spreadsheet button

E

EllenM

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
 
F

fredg

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.
 
Top