I would like to be able to generate an iCal file based on the table in the attached zip file. This would be for import into the Google Calendar. The information for the event would need to be the [Contest Level], SportName,[Home/Away],ContestDate,and ContestTime fields. If the event is a tournament, the TourneyEnd Date would be populated and would need to be represented in the startdate to enddate range on the calendar. All other events are single day events.
I would like Home events to be represented by H and Away events to represented by A.
There is not an ending time for these events, so this would need to be compensated for in the resulting iCal file.
Users should be able to browse to the location where they want to save the iCal file as part of the process.
This needs to be incorporated completely into an Access 2002 database.
