TransferText doesn't exist

[heidibbb]

I'm trying to create a macro to import a text file to my database and from what I can gather from my research, I should use TransferText.

I am using MS Access 2007 and TransferText does not exist in my list of actions when creating the macro.

any thoughts on a plan b?

 

[Joe4]

For some bizarre reason, Microsoft decided not to show you all the options by default.
While in the Macro Editor, click on the "Show All Action" button in the Show/Hide ribbon and you will be able to see it.

 

[heidibbb]

Thanks!

 

[boblarson]

For some bizarre reason,

Well, it isn't bizarre really. But it is another annoying attempt to keep "unsafe" actions segregated so that you can know which are classified as "safe" and which are potentially unsafe. If you do not use VBA in your databases and only safe macro actions then it will run without having to be in a trusted location or without having to click the Enable Code button.

 

[Joe4]

Interesting...
There is a method to their madness (at least sometimes!).