type mismatch errors querying data from spreadsheet
Posted
by
user2984933
on Super User
See other posts from Super User
or by user2984933
Published on 2013-11-12T21:10:16Z
Indexed on
2013/11/12
21:57 UTC
Read the original article
Hit count: 189
microsoft-excel-2010
In EXCEL 2010 I am trying to querying data in another spreadsheet. The data range in the source sheet/ file is named (DATABASE). The Date field in the database is formatted as short date and when I query the date without criteria I get a different format of European datesYYYY-MM-DD with time in the results. When I use criteria and a specific date in the date field criteria grid using English format MM-DD-YYYY I get results. When I set parameters looking at destination file cells for the date for the parameters, I get Type mismatch EVEN THOUGHT THE CELLS ARE Short date Formatted. This worked perfectly in my 2003 version of EXCEL. Now I am running Win 7 -64 and Office 2010 Pro. Why does the query throw Mismatch with cell references for the parameters but accepts hard value dates in any date format? (MSQRY32.EXE)
© Super User or respective owner