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.