ACCESS export wizard

  • Thread starter Thread starter Yossi evenzur
  • Start date Start date
Y

Yossi evenzur

Hi experts
when i export a query to excel 2003 the result file contains the date format
in "custom" format. here are 2 question
1) is there an export wizard for EXCEL?
2) why the export format is set to "custom"?
BTW: I changed the regional settings date format to English UK
 
Seems to me that Excel just uses the regional settings, unless you've set the format of the destination cells to something different. Check your settings in Excel - both the cell format and in Tools Options.


--
Joan Wild
Microsoft Access MVP
: Hi experts
: when i export a query to excel 2003 the result file contains the date format
: in "custom" format. here are 2 question
: 1) is there an export wizard for EXCEL?
: 2) why the export format is set to "custom"?
: BTW: I changed the regional settings date format to English UK
 
Joan Wild said:
Seems to me that Excel just uses the regional settings, unless you've set the format of the destination cells to something different. Check your settings in Excel - both the cell format and in Tools Options.


--
Joan Wild
Microsoft Access MVP
: Hi experts
: when i export a query to excel 2003 the result file contains the date format
: in "custom" format. here are 2 question
: 1) is there an export wizard for EXCEL?
: 2) why the export format is set to "custom"?
: BTW: I changed the regional settings date format to English UK
I checked the excel settings, no reference to the date, regional setting is set for2 options , short date and long date, the short date is ok but i can't modify the long date and it seems like the excel prefers this format.
Click to expand...
 
Excel (like Access) doesn't prefer a certain format. Dates are always stored as a number with the integer portion the number of days since Dec 30, 1899 and the decimal portion the time (expressed as part of a day). The format is just that, how it appears on screen to the user.

Are you saying that Excel doesn't recognize the values as dates?

--
Joan Wild
Microsoft Access MVP
:
:
: "Joan Wild" wrote:
:
: > Seems to me that Excel just uses the regional settings, unless you've set the format of the destination cells to something different. Check your settings in Excel - both the cell format and in Tools Options.
: >
: >
: > --
: > Joan Wild
: > Microsoft Access MVP
: > : Hi experts
: > : when i export a query to excel 2003 the result file contains the date format
: > : in "custom" format. here are 2 question
: > : 1) is there an export wizard for EXCEL?
: > : 2) why the export format is set to "custom"?
: > : BTW: I changed the regional settings date format to English UK
: > I checked the excel settings, no reference to the date, regional setting is set for2 options , short date and long date, the short date is ok but i can't modify the long date and it seems like the excel prefers this format.
 
Back
Top