• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1868
  • Last Modified:

Remove the dollar sign from value when exporting to csv

Hello Experts,

I have a query that I need to export to CSV, now I have accomplished that with the following command: DoCmd.TransferText acExportDelim, "SOJournal Export Spec", "qrySOJournalExport", ExportFileName, however, since one of the fields is in currency format, I need that value to be exported without the $ sign as the file will be imported into peachtree and it does not allow the $ symbol on the import process.
1 Solution
Patrick MatthewsCommented:
Hello corubert,

In your query, force a type conversion:

SELECT Field1, Field2, CDbl(CurrencyField)
FROM SomeTable


corubertAuthor Commented:

Thanks for your comment, however, after making the change in the query, when I export to csv file, I still get the $ symbol in front of the value.
In your query qrySOJournalExport, use the CDbl function and export the query through the same command
DoCmd.TransferText acExportDelim, "SOJournal Export Spec", "qrySOJournalExport", ExportFileName
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now