Hello and thank you for this forum.
I was able to import a calendar from an Excel spreadsheet into SharePoint 2007. (Note: The calendar was originally in SharePoint 2003. I exported it to Outlook 2003 and from there to Excel 2003 SP3).
The appointments came up on the appropriate days after I changed the data type of the StartDate and EndDate fields to Date. However, all the appointments are set to start and end at 1am or 2am, regardless of the real start and end times.
To get around this, I have tried several things...
1. Setting the data type of the StartTime and EndTime fields to Date/Time.
2. Creating a calculated column containing the StartDate/StartTime and EndDate/EndTime (with a Date/Time return type) and using those concatenated values for the begin/end.
3. Concatenating the StartDate/StartTime and EndDate/EndTime via formulas in the Excel spreadsheet itself and using those values for the begin/end when importing.
The result is always the same...the time part of the data get wiped and set to 1am or 2am.
Can you please help me? I'm under a tight deadline.
Thanks in advance,
-J
