Importing data

  • Thread starter Linda Wakefield
  • Start date
L

Linda Wakefield

When I try to import data from two access database tables
using query I get a message "type mismatch in expression"
does anybody know what this means and how to rectify it?
 
C

CLR

From Google..........

http://www.microsoft.com/learning/books/troubleshooting/access/default.asp

Queries: Selection Criteria
Quick Fix: After running a query I see the following message, "Type mismatch
in expression"


You try to run the query you just created and you see the message, "Type
mismatch in expression." The problem isn't really in an expression but
rather it is caused by incompatible data types used to relate the tables in
the query design. The mismatch doesn't show up until you run the query and
the fields are actually compared.

To solve this problem, be sure to relate the tables in the Relationship
window before you create the query. Mismatches are caught right away in the
Relationships window rather than when the query is run.

hth
Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query linked to Excel doesn't work 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access #Error & Excel Pivot 0
Can't create a report from my query in Access 1
Access Importing csv daily files into access 2007 1
How come I don't see the dropdown list for runsavedimportsexports macro 0
Access 2000 Question 1
data object / text box integration 2

Top