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

sqlite-odbc write conflict 2
Adding data to MS Access from csv file 0
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Create a dynamic master file 1
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Change how script is viewed on page. 4
Table Security in Access 2013 1

Top