1. You probably didn't create a named range for the entire range you are
importing.
2. Windows CSV will also work. The main reason for using Excel is because
it's easier to see the fields and you can use Excel tools to automate
creating the items.... but its just as easy to save a CSV from Excel.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"Philip Stromme" wrote in message
...
It has been awhile since I figured this out, so my details might not be
exact...

I discovered the same problem that you are having. On a whim, I decided to
save the file as a comma separated values (*.csv) file, rather than an
*.xls
file. When I did that, it imported everything correctly. You start the
same
way - Import from another file, then select Comma Separated Values. If I
remember correctly, there are two options for importing csv files - DOS
and
Windows. I used the DOS selection, and it worked fine. I don't know if
using
the Windows selection would make a difference or not.

Good luck,
~ Phil

"Philip Stromme" wrote:

I was looking for this same information.
I tried using the technique in the webpage you gave, but it didn't work
right. It would only import one item from the excel spreadsheet, instead
of
all of the items.

I see a certain a student once every 4 school days. Here is what I did:
1) I made a spreadsheet listing each date that I will see that student:
Subject StartDate StartTime EndDate EndTime
Susie 9/4/2007 10:25:00 AM 9/4/2007 11:15:00 AM
Susie 9/10/2007 10:25:00 AM 9/10/2007 11:15:00 AM
Susie 9/14/2007 10:25:00 AM 9/14/2007 11:15:00 AM
Susie 9/20/2007 10:25:00 AM 9/20/2007 11:15:00 AM
Susie 9/26/2007 10:25:00 AM 9/26/2007 11:15:00 AM
2) I imported the spreadsheet into Outlook.
3) When I verified that the data was imported correctly, only one
instance
was imported.

Can you help me figure out what's going wrong?

Thanks,
~ Phil


"Diane Poremsky" wrote:

no, not really.... every 6 days won't work unless he goes to school on
weekends... the easiest way to do it is to create the items in Excel
and
import into the calendar.
general concept is he
http://www.outlook-tips.net/howto/countdown.htm.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"pocono24" wrote in message
...
My son just started school today and there school runs on a 6 day
cycle.
For
example day 1 is gym, day 2 is art and so on. Is there a way to set
this
up
as a reminder in outlook calender for the 6 days without doing each
one
seperate for the 180 school days
thanks
sam