>>When you append into a table with an n(7,2) field from a text file containing numbers without decimal points, you should get the following:
>>0001234 -> 1234.00
>>0012345 -> 12345.0
>>0123456 -> 123456
>>1234567 -> 1234567
>>
>>But one time recently, I got
>>0001234 -> 12.34
>>0012345 -> 123.45
>>0123456 -> 1234.56
>>1234567 -> 12345.6
>>I have not been able to reproduce this one-time result. Any idea of how to get it, so I can be sure to avoid it?
>>
>>-Dave Scott
>Dave,
>The first one should be got by "type SDF" while the second "type delimited".
>Cetin
Ooops. My ignorance there sorry. The numbers you should get are like in your first example.
Cetin