Exporting Calendar data to Excel

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

Monthly I export calendar appointment data to excel for a report. The date
appears to be exported as text (which means I have to manually move
appointments to put them into date order) and appointments that are exported
aren't confined to the To: From: dates that I type in.

Its been this way since Outlook 98. Microsoft has never fixed this "bug" to
my knowledge. Am I doing something wrong or is there a fix I don't know
about? I currently use Office 2003.

In Excel, I've tried changing the appointment date column to a date column,
but this doesn't help. In Outlook I tried exporting to other file formats
such as Access, but this hasn't helped.

Is there a fix or am I doing something wrong?

Randy
 
Randy said:
Monthly I export calendar appointment data to excel for a report. The date
appears to be exported as text (which means I have to manually move
appointments to put them into date order) and appointments that are exported
aren't confined to the To: From: dates that I type in.

Its been this way since Outlook 98. Microsoft has never fixed this "bug" to
my knowledge. Am I doing something wrong or is there a fix I don't know
about? I currently use Office 2003.

In Excel, I've tried changing the appointment date column to a date column,
but this doesn't help. In Outlook I tried exporting to other file formats
such as Access, but this hasn't helped.

Is there a fix or am I doing something wrong?

Randy
Click to expand...

When you try to sort the date column, do you get a dialog box up, asking
you whether you want to sort text that looks like numbers? If you choose
this option, then it will sort in date order AFAIK (I've just tried it
with mine!)
 
Gordon said:
When you try to sort the date column, do you get a dialog box up, asking
you whether you want to sort text that looks like numbers? If you choose
this option, then it will sort in date order AFAIK (I've just tried it
with mine!)

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk
Click to expand...

A dialog box does not come up. And I have never bothered to determine what
it is sorting on, other than that is it sorting improperly. I'm using Excel
2003, of course.

On second thought.... Its probably been 9 months since I have attempted to
sort on the date column and my memory may not be accurate. I'll be back in
the office on Thursday and I'll give your suggestion a shot. Thanks.

Randy
 
Back
Top