Import Excel via button

[Susan]

I currently have a large report that I generate. I input
an Excel spreadsheet into Access 2000 and use a command
button to run it. I would like to automate this so the
user can run it. The users do not have permission to go
into the design (database window) and therefore cannot go
to File, Get External, Import. I looked under Macro's
optons and cannot find an Import command ---- and I do not
know VB/SQL to do coding.

Any help out there? Thank you.

 

[Ken Snell]

In a macro, you can use TransferSpreadsheet command to import a sheet from
an EXCEL file. It's explained in Help file. Post back if you have questionsn
about it. Note that you either will have to hardcode the sheet name and file
name and path into the action, or use InputBox to get the info from the
user.

If you want to allow the user the ability to navigate to the file using the
"Open File" window, you'll need to use VBA and special code to do that.