Export Specification Question

[Guest]

Hi,

I made an Export Specification called "PO Export" to export my query with no
quotes (as the other program requires it for import).

I am under the understanding that I can now call this export specification
using Docmd.TransferText but so far I cannot get it to work.

I am obviously doing something wrong, can anyone point me in the correct
direction?

Do I need to reference my original query and the export specification
together somehow?

Thanks

 

[Ken Snell \(MVP\)]

Show us what you've tried... hard to provide suggestions without seeing what
you tried and isn't working.

 

[Guest]

It seems that using VBA i couldn't do it (or at least Help doesn't offer any
specifications) but a macro (transfertext) works fine.

 

[Ken Snell \(MVP\)]

Second argument of the VBA method DoCmd.TransferText is the name of the
specification.