Exporting Data

[Guest]

I'm trying to export data from a table to a text file using the TransferText
macro command. I've set all my number field types to double with a standard
format and no decimal places.

However when the table exports and produces a text file all numeric fields
have decimal places. The text file will be loaded into another oracle based
application and it doesn't like the decimal places.

How can I remove them ?

 

[Guest]

Create a query based on the table.

Surround all the problem fields with the Int or Fix function which chops off
the decimal portion. Might want to read up on them as the treat negative
numbers differently. There's also the CLng function which rounds up or down.

Export the query instead of the table.

A double field can contain decimals. Formatting is just how the data is
displayed and not what is actually in the table. If you do not now, nor never
will, need decimal places in those fields, change them to a Long. Warning:
That will remove the decimals on existing records.

 

[GeoffG]

Do you really need to use the Double data type?

Could you use Long (Integer) instead?

Geoff