Use a Button to Link to Access's Import Function?

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

Guest

Hello,

Is there a way to use a button on a form to call External Data -> Import
Excel option? I want the user to be able to use Access's built in import
option, but would rather have them do it through a form instead of the
toolbar/ribbon.

Thanks.
 
Nick,

It may be worthwhile for you to take a look at DoCmd.TransferSpreadsheet.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Back
Top