Scientific extra's

[Ralph]

I am trying to export a number field to a .csv (comma delimited) file to load
to another computer and for some reason I cannot find a format or setting
that gets rid of the scientific notations for some fileds that were
calcualted -- i.e. 3.44666349255741e-03. They will not load to the other
computer. The format filed in table design doesn't seem to have an affect.
I've tried #.00 in the format and 2 decimal places in the decimal field.
".csv" export does not give the option to select individual field types and
setting up a 'spec' doesn't seem to work for me either!! Any help would be
aprreciated!! Thanks!!

 

[Jerry Whittle]

Formatting only changes how the data looks and not what is actually stored in
the table, or in your case, exported.

Instead of exporting the table directly, create a query and use the format
function there then export. However that will change the number to text so
that might cause a problem. Using the CCur function might be a better choice
as currency is still a number and usually only has two decimal places. You
might have the pesky dollar or some other currency symbol to deal with though.

 

[gllincoln]

Hi Ralph,

If you base the export on a query of the data, rather than the table, then
you can exert more control over what is exported.

Might take some strong arm tactics to get the data to behave - but it can be
done.

For example, instead of
SELECT myDoubleCol '(hypothetical field name)

we define this column

SELECT CDbl(Format([myDoubleCol], "General")) as myNumericDouble

Hope this helps,
Gordon