ExportTableTo dbaseIII causes L integerToDouble error 1

[CliffordTheRedDog]

Hi all,
I am exporting a tble from MSAccess to dbase III format but the Long Interger field is changing to a "double" field which is being read by clipper as 1100.0000 with four decimals rather than 1100; this is creating downstream problems. is there a way in access that i can force the output to stay the same?
(i will be out while monday, so will reply then)
TIA
Cliff

 

[willir]

I got read of my dBase when I rebuilt my computer last so I can not test anything.

Sometimes it helps to use a text value instead of a numeric to preserve the data type.

For example...

To force an integer
strNum = format(lngNum,"####0")

To force a decimal
strNum = format(lngNum,"####0.00")

When importing the field, dBase will hopefully treat it as the correct numeric type.

 

[CliffordTheRedDog]

willir
Thanks, will investigate before responding properly
Cliff

 

[CliffordTheRedDog]

willir,
Will keep your suggestion on file as have changed the other software to strip out the trailing 0's. Thanks for posting
Cliff