Exporting in UTF-8 format

[Eddie Mason]

I am running a query from a form to export the selected records to a .csv file. This works perfectly except that I want it exported in UFT-8 format. Is there way that I can do this?

The code that I am using is as follows:

The fields appended to NewProducts are so that the query can be run several times, on different selected record sets, without overwriting early exports.

DoCmd.TransferText acExportDelim, , "qryPublishNewProd","C:\Updates\Imports\NewProducts" & DateY & DateM & DateD & Suff1 & ".csv", -1

I hope someone can help on this.

Kind regards

Eddie

 

[Estuardo]

G'd evening Eddie,
The last parameter of TransferText is Codepage. For your requirements should be 65001.
here is the MsoEncoding Enumeration Page
G'd luck

 

[Eddie Mason]

Hi Estuardo,

Many thanks for you help, the problem is now solved. I would never have found it without your help.

Kind regards,

Eddie

 

[Estuardo]

You're very welcome my friend. I'm glad it helped