Get external data (1 Viewer)

[sandhurstUK]

Is is possible to create a macro which runs the Get External Data function.
What I want to do is create a macro which runs off a command button which does the following:

Deletes the contents of a table
Opens Excel (to a specific file location) Imports the data into the existing table
Runs a make table qry (already there and converts mutiple entries into recordsets).

I am not sure whether this is possible and would appreciate any help going.
Thanks

 

[Rich_Lovina]

Look at yr options under the TransferDatabase command in Macro Design view. You can do it all there. Read yr F1 helps along the way.

 

[Pat Hartman]

Use the TransferSpreadsheet Method to do this in one step.

 

[sandhurstUK]

Excellent, job done.
many thanks