A Question, what do you wan to do about the last line of the file, as the data does not fit with the Table headings?
Do you need that Summmary?

ps even though a manual Import works the Docmd.TransferText refuses to accept the file name with the fullstops in, so I am using a different technique which is working fine.