ODBC dBase III Driver numeric+(2 precision) type not supported

[halbqc]

I'm trying, with a VB, to access a dBase III table with ODBC dBase Driver, but it seems to be not accepted with a NUMERIC (with 2 precision) field in it.

see:

http://msdn.microsoft.com/library/d...ry/en-us/odbc/htm/odbcjetdbase_data_types.asp

Changing to an other ODBC Driver like FoxPro cause me other problems
(string values with a \r or \n could not be inserted) and I have many tables with many Memo fields.

I can't change the data type because the table is already filled with 26 000 records and I need the 2 precision digits. Setting the type to float don't change anything in the table structure, it stay with the "N" value for numeric.


Please, if somebody have an idea go ahead....

 

[MiggyD]

Do you have the option to convert (more like create) a .mdb file instead of .dbf?

If so, I'd convert it. As was indicated on MSDN, Dbase 4 and below have packed numeric fields. --MiggyD

Never be afraid to try something new. Remember that amateurs built the Ark. Professionals built the Titanic.