Re: Macro to inport excel file to table in access 2007

[Ken Snell [MVP]]

Use TransferSpreadsheet macro action. It has arguments into which you can
put constants that identify the file name with path, etc.

 

[Leanne]

TransferSpreadsheet isnt showing in the drop down list for macro action

In the help files it is menioned but it isnt showing. is there a reason for
this?

 

[Ken Snell [MVP]]

You need to "Show All Macros". See this help article for more information.
http://office.microsoft.com/en-us/access/HA012142021033.aspx

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/