Setting format in TransferSpreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My currency field have 4 decimal point in my Access Table, but after I
transfer to Excel using functino TransferSpreadsheet, it become 2 decimal
point only, why? Can I solver the problem?

Second, how do i set the date format to "dd-mmm-yyyy" for all my date field
type when using function TransferSpreadsheet to export data to excel from
access?
 
HongSeng said:
My currency field have 4 decimal point in my Access Table, but after I
transfer to Excel using functino TransferSpreadsheet, it become 2 decimal
point only, why? Can I solver the problem?
Click to expand...

I cannot reproduce when exporting using a query e.g.

SELECT MyCurrCol
INTO
[Excel 8.0;Database=C:\Temp.xls;].MyNewSheet
FROM MyTestTable
;

I get all four decimal places. So perhaps the solution is to use a
query! FWIW with currency data type I get numericscale=4 and
precision=19 by default (can it even be changed, I wonder?)
how do i set the date format to "dd-mmm-yyyy" for all my date field
type when using function TransferSpreadsheet to export data to excel from
access?
Click to expand...

AFAIK the format for dates, currency, etc is determined by the
machine's Regional Settings.

Jamie.

--
 
Back
Top