Transfer Text, Export Delimited w/ Number formated to 4 decimals.

L

luchshel

Want to export table to delimited text using a macro. The macro uses
Transfer Text, Export Delimited. It works but the export truncates a four
digit decimal field to two digits.

Table Record:
Field 1 (Text): 3011-52020
Field 2 (Decimal, 18,4,4): 1000.5555

Output Record
Field 1: "3011-52020",
Field 2: 1000.55

I need the four decimal places. Assistance would be appreciated.
 
S

Steve Schapel

Luchshel,

I am not sure why this is happening. However, here are two ideas to try...

1. Change the data type of this field to Currency, and set its Format as
General Number.
2. Do your export from a query, and use this in the place of Field 2:
Format([Field 2],"#.0000")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Delimited 1
Export from MS Access 2007 to Quickbooks IIF - How can I create a tabdelimited text file from Access 2
Access 2003 csv export decimals 0
Output To text with no headers ? 3
Export to Tab delimited text file 4
Export table to txt file with a variable filename 0
Transfer Text - want to add a Header Row 3
Macro to Import TXT file and format the file 3

Top