importing from excel question.

  • Thread starter Thread starter drewlucas
  • Start date Start date
D

drewlucas

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
 
Have you tried creating an event or 2 in Outlook, export that to Excel and
then compare the two files?

--
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.
| 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
 
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.

"Milly Staples [MVP - Outlook]"
 
Back
Top