export into text File

[monadel]

Hi guys,

Does anyone can help how to export data into text file please.
Any help will appreciate it.

Thank you

[FishVal]

DoCmd.TransferT ext

Kind regards,
Fish.

[monadel]

I can export to text the data but I have to hard code the output file.
like:
file_name = "H:\txtFileName .txt"

How do you set the output to a new .txt file ( just open a new one)?

cheers

[FishVal]

So use variable instead of constant.

[NeoPa]

It's hard to answer your question correctly if you don't ask it properly.
Please try to write your questions clearly in future.