Import Data From Excel into Access 2010

[TimTDP]

Using VBA, I need to import the attached Excel file into an Access 2010 database
My problems include:
* Access 2010 doesn't appear to have import funtionality of previous versions!
* The first row of the Excel file has strange characters!

I simply want to import the data into tblTempData which has the following fields:
PointNumber
TimeStamp
Reading
Location
Events

How do I do this?
I have 805 files to import!