var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Decimal digits while exporting tables into txt files
I need to export some Access tables into .txt files
When I try to export with Access tool, even if I define Specifications, it exports numbers with decimal digits (i.e. every number ends with ,00 or .00)
I'd like not to have decimal digits
Is there a way to do so without writing code?
Write a SELECT query that grabs all the data you want, except with the field in question you do something like:
Then export the query instead of the table.
For more help with the Format function see here.
Alternatlively, I suppose you could use the CLng function.
Me.Geek = True