How do I export a MA query to tab delimited .txt file?

[dalex]

How do I build a macro that exports a Microsoft Access query to a tab delimited .txt file?

 

[Remou]

Use TransferText.

 

[dalex]

Thanks Remou...I am now very close to where I want to be. My only challenge now is that the file exports as a csv; I need it to export tab delimited. I think I need to control this via the Specification name box, however I am not sure as the specification box gives me an ambiguous list of drop down items.

dalex

 

[Remou]

First export manually and save the specification using the Advanced button. You will then have a suitable specification and its name.

 

[dalex]

Thnak you. I am good now. Your small assistance has made a big difference.

Thanks again,,
dalex