From Access to Dbase format,Nr.Format five zero's !?

[petrovlis]

I have to transform regularly Msaccess 2003 qry-make-table
to Access-table and then export that table to
DbaseIV format. Works fine, but I get the CompanyID field
in the format : 125,00000 in stead of 125

My file is more than 65000 so via Excel conversion is impossible.
Is there somewhere is "simple" way to convert without
the five zero's?? I need update/covert to ACT! 6.
William

 

[Golom]

This is probably an artifact of numeric conversion that's going on in the Access to dBase driver and is happening because your field data type in Access isn't being converted correctly.

First though ... is the comma in "125,00000" a decimal place (i.e. European convention) or is it a separator character (North American Convention)?

I'm assuming decimal place.

Try doing something like CLng(IDField). That should force the datatype to a 32-bit long integer. If your numbers are all less than 32768 then use CInt(IDField) for a 16-bit integer.