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

  • Thread starter Thread starter Ken Snell [MVP]
  • Start date Start date
K

Ken Snell [MVP]

Use TransferSpreadsheet macro action. It has arguments into which you can
put constants that identify the file name with path, etc.
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cannot expand named range 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Prompt for a file name in a script macro 0
How to import 2 spreadsheet files with one file name entry 5
How to count table records in a macro 1
TransferSpreadsheet macro action is not available. 1
Import Excel or CSV File Using TransferSpreadsheet or TransferText 1
The expression you used has a function name Access can't find 2

Back
Top