importing from excel question.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

drewlucas - 24 May 2005 13:29 GMT

I have outlook 2002 along with excel 2002 and am trying to import my diary
which is in Excel into outlooks calender.
I've got a named range in excel with headers of "subject", "start date" and
"start time".
Outlook imports all the data quite happily but all the start times are now
as all day events! Subject and date information are correct.
The cells are formated in Excel as "time" + "13:30:55".
I think it's something to do with the formating in Excel but can't fix the
problem.
If anybody knows how to do it, I would be very very gratefull.

Kind regard,
Drew Lucas

Reply to this Message

Milly Staples [MVP - Outlook] - 25 May 2005 04:46 GMT

Have you tried creating an event or 2 in Outlook, export that to Excel and
then compare the two files?

Signature

Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After furious head scratching, drewlucas asked:

| I have outlook 2002 along with excel 2002 and am trying to import my
| diary which is in Excel into outlooks calender.
[quoted text clipped - 9 lines]
| Kind regard,
| Drew Lucas

Reply to this Message

drewlucas - 25 May 2005 18:16 GMT

You are almost a genius.

It certainly shows me that the format should be "'13:30:55" (extra
apostrophe makes the numbers text me thinks?). The only problem I have now
is getting that format in Excel? I'll have a play tomorrow and see what
comes up. Might have to switch to the excel newsgroup? Many thanks for
pointing me in the right direction.

Regards, Drew.

> Have you tried creating an event or 2 in Outlook, export that to Excel and
> then compare the two files?
[quoted text clipped - 12 lines]
> | Kind regard,
> | Drew Lucas

Reply to this Message