Query linked to Excel doesn't work

  • Thread starter Thread starter Eva
  • Start date Start date
E

Eva

Hi
I have a database where one query is linked to Excel file. Query works fine,
but I can't refresh it in Excel and I get the info:"[Microsoft][ODBC
Microsoft Access Driver]Data type mismatch in criteria expression"
what does it mean? When I double click in Access there is no error message.
I also tried to relink it again in a new sheet but I can import it (I don't
see the query when I get to the "selet table" part).
Can you advise?
--


Greatly appreciated

Eva
 
What that usually means is that a datatype from excel is not the same as the
datatype in access. You may have a field in the excel sheet set as date and
you are trying to save it in access as a text field. Or a text field in excel
you have identified in access as number field. OR you have a criteria (like a
formula) in excel that access does not know how to translate.
 
Thank you very much

--
Please click "yes" if this post helped you!

Greatly appreciated

Eva


golfinray said:
What that usually means is that a datatype from excel is not the same as the
datatype in access. You may have a field in the excel sheet set as date and
you are trying to save it in access as a text field. Or a text field in excel
you have identified in access as number field. OR you have a criteria (like a
formula) in excel that access does not know how to translate.
--
Milton Purdy
ACCESS
State of Arkansas


Eva said:
Hi
I have a database where one query is linked to Excel file. Query works fine,
but I can't refresh it in Excel and I get the info:"[Microsoft][ODBC
Microsoft Access Driver]Data type mismatch in criteria expression"
what does it mean? When I double click in Access there is no error message.
I also tried to relink it again in a new sheet but I can import it (I don't
see the query when I get to the "selet table" part).
Can you advise?
--


Greatly appreciated

Eva
Click to expand...
Click to expand...
 
Eva said:
Hi
I have a database where one query is linked to Excel file. Query works
fine,
but I can't refresh it in Excel and I get the info:"[Microsoft][ODBC
Microsoft Access Driver]Data type mismatch in criteria expression"
what does it mean? When I double click in Access there is no error
message.
I also tried to relink it again in a new sheet but I can import it (I
don't
see the query when I get to the "selet table" part).
Can you advise?
--


Greatly appreciated

Eva
Click to expand...
 
(e-mail address removed)
golfinray said:
What that usually means is that a datatype from excel is not the same as
the
datatype in access. You may have a field in the excel sheet set as date
and
you are trying to save it in access as a text field. Or a text field in
excel
you have identified in access as number field. OR you have a criteria
(like a
formula) in excel that access does not know how to translate.
--
Milton Purdy
ACCESS
State of Arkansas


Eva said:
Hi
I have a database where one query is linked to Excel file. Query works
fine,
but I can't refresh it in Excel and I get the info:"[Microsoft][ODBC
Microsoft Access Driver]Data type mismatch in criteria expression"
what does it mean? When I double click in Access there is no error
message.
I also tried to relink it again in a new sheet but I can import it (I
don't
see the query when I get to the "selet table" part).
Can you advise?
--


Greatly appreciated

Eva
Click to expand...
Click to expand...
 
Ninja Turtle is cute but have to be carefully placed. I`m talking about our
mites. Behind the icon leads to gangsarisme fakes.
Dangerious.

James Hall said:
(e-mail address removed)
golfinray said:
What that usually means is that a datatype from excel is not the same as
the
datatype in access. You may have a field in the excel sheet set as date
and
you are trying to save it in access as a text field. Or a text field in
excel
you have identified in access as number field. OR you have a criteria
(like a
formula) in excel that access does not know how to translate.
--
Milton Purdy
ACCESS
State of Arkansas


Eva said:
Hi
I have a database where one query is linked to Excel file. Query works
fine,
but I can't refresh it in Excel and I get the info:"[Microsoft][ODBC
Microsoft Access Driver]Data type mismatch in criteria expression"
what does it mean? When I double click in Access there is no error
message.
I also tried to relink it again in a new sheet but I can import it (I
don't
see the query when I get to the "selet table" part).
Can you advise?
--


Greatly appreciated

Eva
Click to expand...
Click to expand...
Click to expand...
 
Back
Top