If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Exports and decimals
Anyone know how to export a table to a text file and get
more than 2 decimals? |
#2
|
|||
|
|||
Exports and decimals
Set up an export specification that specifies the decimal format for the
field and then use that export spec in a macro (TransferText) or VBA code (DoCmd.TransferText). You set up your spec by starting to do the export manually, and when the wizard window opens, click on the Advanced button at bottom left -- you then can set all the export specification parameters and save the spec as whatever name you want. Then cancel the export and use the spec name in one of the above methods. -- Ken Snell MS ACCESS MVP "Ben Jammin" wrote in message ... Anyone know how to export a table to a text file and get more than 2 decimals? |
#3
|
|||
|
|||
Exports and decimals
Thanks for the help.
I tried what you said but don't see any way to change the decimals in the Advanced screen. -----Original Message----- Set up an export specification that specifies the decimal format for the field and then use that export spec in a macro (TransferText) or VBA code (DoCmd.TransferText). You set up your spec by starting to do the export manually, and when the wizard window opens, click on the Advanced button at bottom left -- you then can set all the export specification parameters and save the spec as whatever name you want. Then cancel the export and use the spec name in one of the above methods. -- Ken Snell MS ACCESS MVP "Ben Jammin" wrote in message ... Anyone know how to export a table to a text file and get more than 2 decimals? . |
#4
|
|||
|
|||
Exports and decimals
My oversight....that's what I get for doing things from memory!
Replace the field in your query with a calculated field that formats the output the way you want for decimal points. For example, if I want 4 decimal places: OutputField: Format([FieldName], "0.0000") -- Ken Snell MS ACCESS MVP "Ben Jammin" wrote in message ... Thanks for the help. I tried what you said but don't see any way to change the decimals in the Advanced screen. -----Original Message----- Set up an export specification that specifies the decimal format for the field and then use that export spec in a macro (TransferText) or VBA code (DoCmd.TransferText). You set up your spec by starting to do the export manually, and when the wizard window opens, click on the Advanced button at bottom left -- you then can set all the export specification parameters and save the spec as whatever name you want. Then cancel the export and use the spec name in one of the above methods. -- Ken Snell MS ACCESS MVP "Ben Jammin" wrote in message ... Anyone know how to export a table to a text file and get more than 2 decimals? . |
Thread Tools | |
Display Modes | |
|
|