TransferText and the pound sign

[pcsmurf]

In a module I have the code :

DoCmd.TransferText acExportDelim, , cTablename, cOutFilename, True

The table cTablename has text fields that contains the £ sign. Using the above code the £ sign is converted to a œ symbol.

If I use the Export option within Accesss the £ signs are converted fine.

How can I export the £ sign within the VBA code ?

 

[MichaelRed]

hmmmmmmmmmmmm,

Ms. A. "exports" ASCII text. Regional settings, the following application (where you are viewing the transfered "text&quot and the font used (by the following application) to view the transfered text will all have some "effect" on the aparent character set.

Within Ms. A. invoke "HELP" and find the toipic:
Controlling international data display formats for a PART of the discussion.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[mp9]

Might be worth trying OutputTo instead, which takes the syntax:

DoCmd.OutputTo objectType, objectName, outputFormat, outputFile, autoStart, templateFile, encoding

So you might have something like this for an Excel export:

DoCmd.OutputTo acTable, cTablename, acFormatXLS, cOutFilename

http://www22.brinkster.com/accessory/