First, are you aware that you can link an Excel worksheet or Named Range as a table in Access?
This would save you the import.
Second, the append query could be something like this:
INSERT INTO tblCalendarA
(StartDate,
StartTime,
EndTime)
SELECT
MID(StartDate, 2),
MID(StartTime, 2),
MID(EndTime, 2)
FROM