R
RonH
On an Access form button, when using Docmd.TransferText,
Access is ignoring the Output Specification criteria
regarding Text Qualifier "none". If I Export the query
manually, all is fine. When I use a command line such as:
{DoCmd.TransferText acExportDelim, BHDF,
qryBHDF, "C:\ANEW_BHDF.CSV", -1} where 'BHDF' is the saved
Specification Name, I still get the quotes around text
fields. I guess this is one for Microsoft because the only
thing I can see is that it's a bug in their code. But, if
anyone has any suggestions... please reply. I am all up to
date with Microsoft's torturous updates. Also... is there
anyway to change the DoCmd.OutputTo acExportTXT to NOT
include all those graphical outlines around my data, which
is sooo useless, or is this just another thing that will
NOT change about Access?
Access is ignoring the Output Specification criteria
regarding Text Qualifier "none". If I Export the query
manually, all is fine. When I use a command line such as:
{DoCmd.TransferText acExportDelim, BHDF,
qryBHDF, "C:\ANEW_BHDF.CSV", -1} where 'BHDF' is the saved
Specification Name, I still get the quotes around text
fields. I guess this is one for Microsoft because the only
thing I can see is that it's a bug in their code. But, if
anyone has any suggestions... please reply. I am all up to
date with Microsoft's torturous updates. Also... is there
anyway to change the DoCmd.OutputTo acExportTXT to NOT
include all those graphical outlines around my data, which
is sooo useless, or is this just another thing that will
NOT change about Access?