SQL query works in 2003 but not in 2007

I have a SQL query that runs perfectly in excel 2003 yet I can't get it to run in 2007. Returns 'Run-time error 1004 General ODBC error.' I found a sweet line of code to point out exactly where the error is happening and pastes the error in a cell and it tells me:
[CODE]"[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'BoxPM_Statsdef_1'."[CODE]

I am missing something but not sure what. Anyone have any thoughts?

Ends up being a date formatting issue of all things. I knew the table was good because I could go straight into the sql db and look at it.