"mattie" <ma****@discussions.microsoft.com> wrote in message
news:21**********************************@microsof t.com...
hello everyone,
how do i specify a decimal position for a certain field in my schema file?
(for example:
Col1="AMT" Double Width 10
)
the amount field in the data file does not contain a decimal (i guess it's
assumed).
Not by the schema.
Your assumption is incorrect.
There can be no assumed or implied decimal point using this method.
when i try to import using text provider there is no decimal point. is
there
a way i can get that to work?
The data file must have a point in numeric fields, or whatever character you
specify using DecimalSymbol
You need to go back to whatever generated the text file and change the
process so it puts decimal places in.
Or, if the decimal place is defiinitely implied to (say) 2 places then
import to a table and then divide by 100.
If you're from one of those countries uses commas for decimal points then
you'll also want to consider fixed width fields as comma delimited will be a
bit of a problem.
--
Regards,
Andy O'Neill