Lost decimal place when exporting to cvs

kip

Registered User.
Local time
Today, 07:41
Joined
Mar 19, 2012
Messages
21
I'm using this to export data from a table to a cvs file:

Private Sub SaveAndClose_Click()
Dim PartNumber3 As String
PartNumber3 = Me.[Order Name]
DoCmd.TransferText acExportDelim, , "Rough Order", "C:\Cardinal Order\Rough Orders" + PartNumber3 + ".csv", True
The data in the table has 3 decimal places but the cvs file when viewed in notepad has only 2.

I have tried adjusting the information in the data field as follows:

Field Size = Double
Format = Fixed
Decimal Places = 3

Field Size = Double
Format = [Blank]
Decimal Places = 3

Field Size = Double
Format = [Blank]
Decimal Places =[Blank]

I might see if I really need this as a number and maybe just change it to text but as of right now I'm not sure that I can.

Any help would be greatly appreciated.
 

Users who are viewing this thread

Back
Top Bottom