Query linked to Excel doesn't work

[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

 

[golfinray]

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.

 

[Eva]

Thank you very much

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

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.
--
Milton Purdy
ACCESS
State of Arkansas

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

 

[Michelle Rodriquez]

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

 

[James Hall]

(e-mail address removed)

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

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

 

[Eighte]

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

(e-mail address removed)

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

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