troubleshooting Question

Export table to a csv file without decimal places, dollar signs and apostrophes

Avatar of peispud
peispudFlag for Canada asked on
Microsoft Access
14 Comments1 Solution82 ViewsLast Modified:
Hi.
I using Microsoft Access 365.  I need to export / create a clean csv file.
My table only has 3 fields.

[System ID]          Data type  =  Number         Field Size = Double             Decimal places = 0
[Order Qty]          Data Type = Number          Field Size = Integer             Decimal places  = 0
[Unit Cost] is        Data Type  = Currency        Format = General               decimal places = 2

This is my export command.
 DoCmd.TransferText acExportDelim, , str_tbl_ToExport, strTheDirectory, True, , 65001

I am trying to export a from a table to a CSV file.  Below is the result
 *** Please note that I inserted spaces in this  question to make it easier to read. ***
This is what I get.    

"System ID",                  "Unit Cost",  "Order Qty"
210000000347.00,         $4.20,                    1

See below for what I need.

System ID,              Order Qty,             Unit Cost
210000000347,           4.2,                      1

Any help would be greatly appreciated.
ASKER CERTIFIED SOLUTION
John Tsioumpris
IT Supervisor
Join our community to see this answer!
Unlock 1 Answer and 14 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros