Luchin_plusplus
November 2nd, 2004, 02:53 PM
O'key, this is da problem:
I have Visual Fox Pro 6 and Access 2000 (no chance of upgrading Access, sorry), and I have built a database in Visual Fox Pro. A typical "hello-world" database: name, code, height, weight, hair color, and favourite thread at the CG forum :D .
Of course, the colours and CG forum threads are in separate tables.
Next I have built a 'structural replica' in Access, ie.: the same tables and fields and data types, but no info inside the database. Just a 'placeholder'.
Then when i tried to import the database from VFP, through an ODBC connection, which our teacher taught us how-to, and worked fine until we press OK. Access complained about not being capable of 'access the format of the following field: ', which in the VPF-side is a floating-type ("single"), 2 decimal digits field, and in the Access side is a Number (single), 2 decimal digits field. Me just can't get it...
Everything in the Access table appears as #ERROR, and I can not continue!
I tried Googleing the problem, but everything I got was either solutions to other problems or HTTP-404's.
And I can not just delete the floating point fileds or changing their type, because that's the teacher requierment. Thus I tried to solve the problem, got dizzy, now call out for divine help using the CG forum...
Please help, thanks.
I have Visual Fox Pro 6 and Access 2000 (no chance of upgrading Access, sorry), and I have built a database in Visual Fox Pro. A typical "hello-world" database: name, code, height, weight, hair color, and favourite thread at the CG forum :D .
Of course, the colours and CG forum threads are in separate tables.
Next I have built a 'structural replica' in Access, ie.: the same tables and fields and data types, but no info inside the database. Just a 'placeholder'.
Then when i tried to import the database from VFP, through an ODBC connection, which our teacher taught us how-to, and worked fine until we press OK. Access complained about not being capable of 'access the format of the following field: ', which in the VPF-side is a floating-type ("single"), 2 decimal digits field, and in the Access side is a Number (single), 2 decimal digits field. Me just can't get it...
Everything in the Access table appears as #ERROR, and I can not continue!
I tried Googleing the problem, but everything I got was either solutions to other problems or HTTP-404's.
And I can not just delete the floating point fileds or changing their type, because that's the teacher requierment. Thus I tried to solve the problem, got dizzy, now call out for divine help using the CG forum...
Please help, thanks.