Additional Decimal Places?

[cool101530]

I brought FoxPro database file into Access to do some maintenance on it but when I exported it back, my numeric fields were lengthened to 3 decimal places (which I don't want)although I never touched the field sizes.<br>Any ideas ?<br>Thanks

 

[dgrewe]

If you use the commands<br>use foxtable<br>copy to exchange.cdf delimited<br>start access<br>import from the comma delimited file<br>play with data<br>export to exchange.cdf<br>start fox<br>use foxtable exclu<br>zap <br>append from exchange.cdf delimited<br>there is no way the field size can change.<br><br>You must be creating a new fox table structure from the exported access data.<br>or the numberic fields you mentioned are character fields holding numberic info. <p>David W. Grewe<br><a href=mailtoave@internationalbid.net>Dave@internationalbid.net</a><br><a href= > </a><br>

 

[MikeWood]

Also remember that the way Access stores numerical data is not the same way that FoxPro stores numerical data. <p>Mike Wood<br><a href=mailto:mwood@awod.com>mwood@awod.com</a><br><a href= > </a><br>