Scientific extra's

  • Thread starter Thread starter Ralph
  • Start date Start date
R

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!!
 
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.
 
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
 
Back
Top