Solved

Remove the dollar sign from value when exporting to csv

Posted on 2009-05-14
3
1,715 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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

733 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