MSAccess exports long integer as double causing problem

[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; this is creating downstream problems. is there a way in access that i can force the output to stay the same?
TIA
Cliff

 

[1oldfoxman]

Clifford, you might have better luck posting this in the MS Access forum, since that's the side you're looking to force the change from.

 

[CliffordTheRedDog]

1oldfoxman,
Thanks, have crossposted to both.
Cliff