Access - Linked Excel Sheet query -

i working on database bring number of excel sheets together. have created link between ones in need , set relationships in access.

i have first-year degree experience of microsoft software packages. not going move excel access other team members more comfortable using it. running things reports, creating forms , querying data can easier in access.

the problem:

i trying query data linked spreadsheet , works , doesn't. more none queries return blank when know shouldn't.

is table being linked , not access table?

please see example query have set up

thank in advance.

if assume status on date field criteria treating text, , expression:

like "*/*/2013" 

may cause unexpected return results, depending particularly on default date format of excel. use criteria:

year([status on])=2013 

which more reliable, not depending on formatting of date, purely on fact recognisable date.

i don't have issues linking excel files unless:

• the file open
• the excel files has links other files or macros
• it corrupted in way.

if linking excel file it, ideally, should simple file with, preferably, no other content single table of data.