Cindy Winegarden
10/11/2006 6:20:00 PM
Hi!
I''ve never worked with Dbase II files (only with FoxPro DBFs) but I know
that in Fox DBFs fields of numeric data type are actually stored as
characters. a format N(6,4) means 6 characters wide with 4 after the decimal
point, such as 1.2345 . However, Fox numeric fields will accept non-standard
values such as 1234.5 in the N(6,4) field - in other words any number with 5
digits no matter where the decimal point lies. This can confuse other
databases when accessed via ODBC.
--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy@cindywinegarden.com
<drv62@yahoo.com> wrote in message
news:1160342606.426081.42830@i42g2000cwa.googlegroups.com...
>I have a series of DBF files that I want to import into a SQL database.
> When I query a few of the files using ODBC (DBF driver), OLE.DB (Jet
> 4.0) the fields that are decimal and have values are returned as NULL.
> Looking at the internals, I can see no differences in the headers of
> the files (field types, indexes, etc.) and the non-decimal fields are
> returned ok. Loading them via other DBF viewer utilities the data
> shows as expected. Any ideas?
>
> Thanks
>