Import Excel data into Calendar

  • Thread starter Thread starter donwb
  • Start date Start date
D

donwb

Win XP all patches & updates, Outlook (Office) 2003.
I'm new to Outlook Calendar.
I just lost a homemade one, running in Excel, with macros.
Fortunately, I was able to recover all the data (entries).
These comprise 2 columns in a spreadsheet, date and text entry.
Is it possible to import these into Calendar?
donwb
 
First, you may want to create a couple of calendar items in Outlook and
export them to Excel. Then compare that output with your data and make the
appropriate changes to your file. Then try the import.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.
ALWAYS post your Outlook version.
How to ask a question: http://support.microsoft.com/KB/555375


After furious head scratching, donwb asked:

| Win XP all patches & updates, Outlook (Office) 2003.
| I'm new to Outlook Calendar.
| I just lost a homemade one, running in Excel, with macros.
| Fortunately, I was able to recover all the data (entries).
| These comprise 2 columns in a spreadsheet, date and text entry.
| Is it possible to import these into Calendar?
| donwb
 
Thanks for the response Milly-
I'm working on that and have a supplementary question:-
How do I display a specific date.
For example, I would like to look at 1 June 1967, for example,
so where do I set or type in that date in order to view the Calendar's
entry.
I'm not looking for a whole year's view - just a specific date.
I could keep the mouse on the left arrow
above the small calendar in the Task Pane,
but that would take forever - there must be an easier way.
donwb
 
For example, I would like to look at 1 June 1967, for example,
so where do I set or type in that date in order to view the Calendar's
entry.
Click to expand...

Click Go>Go To Date. Enter June 1, 1967 in the Date field. Click OK.
 
Back
Top