Solved

Remove the dollar sign from value when exporting to csv

Posted on 2009-05-14
3
1,755 Views
Last Modified: 2012-05-07
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.
0
Comment
Question by:corubert
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 24386311
Hello corubert,

In your query, force a type conversion:

SELECT Field1, Field2, CDbl(CurrencyField)
FROM SomeTable

Regards,

Patrick
0
 

Author Comment

by:corubert
ID: 24386703
matthewspatrick,

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.
0
 
LVL 5

Expert Comment

by:noetymology
ID: 24386727
In your query qrySOJournalExport, use the CDbl function and export the query through the same command
DoCmd.TransferText acExportDelim, "SOJournal Export Spec", "qrySOJournalExport", ExportFileName
0

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question