Setting format in TransferSpreadsheet

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

 

[Jamie Collins]

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?

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?

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

Jamie.

--