Problem in saving Date Field in Excel file to CSV

[Peter]

We just copy and paste data from MS Access 2003 to Excel 2003.

When we save the Excel as CSV file, we find that the date has been converted
to American format. We have checked the Regional Settings and Australia is
used. Is there any language setting in Excel ?

Moreover, on another machine, we are able to save to non-American date.
However, we find that for monetary field, most of them are quoted - Like
"$2,000.00" but some are not quoted - like $580.00. Your advice is sought.

Thanks
Peter

 

[Harlan Grove]

We just copy and paste data from MS Access 2003 to Excel 2003.

Meaning you're at the mercy of how Microsoft implements that particular
operation. Try Paste Special to see what you options are.

When we save the Excel as CSV file, we find that the date has been
converted to American format. We have checked the Regional Settings and
Australia is used. Is there any language setting in Excel?

What specific date formats are you using? Meaning are your months shown as
text, e.g., Sep or September, or as numbers?

Moreover, on another machine, we are able to save to non-American date.

Again, what specific date format?

However, we find that for monetary field, most of them are quoted - Like
"$2,000.00" but some are not quoted - like $580.00. . . .

This could occur because of the comma. Excel may consider both $2,000.00 and
$580.00 to be TEXT, but the former contains an embedded comma, which is
presumably also your List Separator character per Windows Regional Settings.
That embedded comma would mean $2,000.00 would need to be quoted, but no
comma in $580.00 would mean it wouldn't need to be quoted.

This could also explain why your dates aren't munged on this other PC: Excel
may consider them to be TEXT as well.

Are you copying the EXACT SAME table or query result from the same database
using the same versions of Access and Excel on both these PCs? If so, then
there's got to be some difference(s) in the regional settings OR Excel's
override international settings on both PCs.