Using Access 2003, I'm using the Transfer Text command to create a text file. The first field in the table containing the data is defined as NUMBER, GENERAL NUMBER with 3 decimal places. Also note that this table is linked to a table in SQL.
When I try and transfer a value like 432.178, the third digit (8) is always truncated. I am using a transfer specification which defines the target field as 10 positions. If I transfer .123, I get 0.12. What am I missing?
When I try and transfer a value like 432.178, the third digit (8) is always truncated. I am using a transfer specification which defines the target field as 10 positions. If I transfer .123, I get 0.12. What am I missing?