I think the problem could be that you have ######## instead of dates in a number of rows. Import your sheet into your database, and you'll get conversion errors (and subsequently a table that doesn't contain #######). Then, try this query:
TRANSFORM Count(tblFile2.Type) AS CountOfType
SELECT tblFile2.Type, Count(tblFile2.Type) AS [Total Of Type]
FROM tblFile2
GROUP BY tblFile2.Type
ORDER BY tblFile2.Type
PIVOT Format([Opened],"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
Note: the attached file has this as tblFile without the 2.