Exporting Data


G

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 ?
 
Ad

Advertisements

G

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.
 
Ad

Advertisements

G

GeoffG

Do you really need to use the Double data type?

Could you use Long (Integer) instead?

Geoff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top