VBA for export query database to text UTF-8 without header field

[su2009]

hi i am new to Microsoft access. I have the following query data:

Code	Name	Date	R	Amt
AA003	PEN	31/10/2016	LA	0.59
AA003	PEN	31/10/2016	NN	10.78
AA003	PEN	31/10/2016	CT	2.4
AA003	PEN	31/10/2016	TU	2.58
AA003	PEN	31/10/2016	LI	90.39

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

I need a VBA for export query database to text UTF-8 without header field and save in a folder. Also i would like the text file display "" and | for each column. Example as follows:

"AA003"|"PEN"|"2016-10-31"|"LA"|"0.59"
"AA003"|"PEN"|"2016-10-31"|"NN"|"10.78"
"AA003"|"PEN"|"2016-10-31"|"CT"|"2.40"
"AA003"|"PEN"|"2016-10-31"|"TU"|"2.58"
"AA003"|"PEN"|"2016-10-31"|"LI"|"90.39"

Any help is highly appreciated. Thank you.

 

[alansidman]

Look at this link and it should get you started

Exporting in UTF-8 format - Access World Forums

 

[su2009]

hi alansidman,

yeah, i managed to get it done. here is my vba:

Public Sub export_query()

DoCmd.TransferText transferType:=acExportDelim, SpecificationName:="Final_Result Export Specification", TableName:="Final_Result", FileName:="C:\Users\USER\Desktop\Final_Result.txt", hasfieldnames:=False, CodePage:=65001


End Sub

Thanks. i learn something today