Advice on how to speed text file export

[accessmatt]

Does anyone have any ideas how to make this query faster upon text file export? It works very fast when I run it in Access but takes forever when I try to export to text file?

SELECT [Target List].First_Nakey 2, [Target List].Last_Nakey 2, [Target List].city, [Target List].state, [Target List].zip, [Target List].TIER, [Target List].NO_SEE, [Target List].LOW_SEE, Union_ALL.[key 2 NUMBER], Union_ALL.[key 1 NUMBER], Union_ALL.[Vendor Unique Id], Union_ALL.PRODUCT, Union_ALL.Content, Union_ALL.[Content 2], Union_ALL.Date, Union_ALL.key 2TRIC, Union_ALL.Vendor, Union_ALL.Key
FROM Union_ALL INNER JOIN [Target List] ON (Union_ALL.[key 1 NUMBER] = [Target List].key 1_NUM) or (Union_ALL.[key 2 NUMBER] = [Target List].key 2NUM);

[ranman256]

Are using TransferText?

[accessmatt]

ranman256, no I guess that's VBA huh? I was using right click > export. What's advantage and what's easiest way to implement it?

Thanks

[ranman256]

it is not vba. it is a macro command

[ItsMe]

The TransferText method may be available from a Macro. However, it is a public member of the DoCmd class and, therefore, is available via VBA.