The VBA Commands TransferText, and Transfer Spreadsheet are used to import.
You may use a saved ImportExport specification* with them. For supported
databases, you can link tables and read/copy them to Access tables. "An
import" is not sufficiently specific for us to be more precise in our
answer.
* I'm assuming that is what you mean by "saved instructions for an import".
--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access
Perhaps I'm missing some nuance, here, but displaying the instructions in
either a label control or a textbox (in which case, you could keep them in
a
table, move backwards and forwards, if they are separate steps, in a Form.
Place a Command Button on the Switchboar to open the form.
If you wanted to be a little more "elaborate" you could code the
equivalent
of an Access Wizard to lead you through the import step by step.
Larry Linson
Microsoft Office Access MVP
Im sorry I was not clear. When the user opens the databasee I do not
want them to have access to the ribbon. Instead I want them to be able
with a click of a button complete the import. I saved the import step
instructions using the wizard but I do not know what that code looks
like. How do I see it and put it behind the button?
