Error importing (or linking to) a Foxpro table

[Braveheart]

I am in the process of converting VFP 6 applications to Access 2003 (a
temporary measure while the organisation I am consulting for decides on
their new data strategy).

When I try to import some of their VFP tables into Access, I get the
error "the decimal field's precision is too small to accept the numeric
you attempted to add" (this corresponds to Access Error 3761). The
Import aborts without creating the new table in the Access database. One
field in the VFP table has a rather large decimal value stored in it.

Any thoughts anyone might have on this problem would be greatly
appreciated.

 

[Cindy Winegarden]

Hi BraveHeart,

I Googled this problem and found the following:


* Update to the latest Jet 4.0 Service Pack.

* Change the data type that the field is assigned to when you import it

* This bug was introduced in the ODBC driver used by Access 2002 and has
never been fixed (or even, AFAIK, been acknowledged by MS). For example, it
also occurs in the OLE DB Provider. You'll be able to get round it by only
using Access 2000 format databases in Access XP when you want to link to a
VFP table that contains offending data.