Excel to Calendar

[ptu]

Hi everybody, I would like to import my one ear agenda from Excel to
Calendar (outlook 2002) I've tried allready without any result (direct or by
..csv file). In Excel, my agenda is on 4 columns : date, time, place and
subject. What is a correcte way to do it?
Bon dimanche à tous
Paul

 

[BillR [MVP]]

The way you did it. You might need to "map custom fields". Another
alternative is to export a blank Calendar from a new Calendar folder and
then use copy and paste to paste the data in the right fields. Import that
into the new calendar folder and, if all is ok, copy to your main Calendar.
I suggest you import to a "dummy" folder just in case there is a problem -
easier to get rid of data.

 

[ptu]

I did it again, and still nothing in my Outlook. This is my way of doing:
in Excel I select and name four colums I want to import (plage nommée in
fr.) Than after mapping, I import, and absolutly nothing apears in my
Outlook...I must be doing something wrong, but what? How to ceate à blanc
calendar? In case of trubble I have a copy of the .pst file
Thanks for your help Paul

 

[BillR [MVP]]

"How to ceate à blanc calendar?"
File | New Folder. Choose a folder of Calendar type and where to create it.
Put a couple of entries in it if you like then export that (CSV format is
usually used) and copy and paste your data into it. Import it back into the
same folder.

 

[ptu]

I give up....
Thanks for trying, but something is really wrong - with me I supose. I'll
have a walk instead.
Paul

 

[jimt]

Hi everybody, I would like to import my one ear agenda from Excel to
Calendar (outlook 2002) I've tried allready without any result (direct or by
.csv file). In Excel, my agenda is on 4 columns : date, time, place and
subject. What is a correcte way to do it?
Bon dimanche à tous
Paul

Try saving your excel information into a CSV file instead of importing
firectly from excel. Check that the CSV file does not contain "s or 's

 

[Anne Chollet]

In fact, there is a lot of ' and " I'll try to take them aut, and import
after. Thank's for the new idea
Paul

 

[Diane Poremsky]

did you create a named range?