>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