Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export Text Wizard - Data Type Mismatch error

Status
Not open for further replies.
tubbers

tubbers

Technical User
Jun 23, 2004
198
US
I have a query that works perfectly but when I go to export it as a .txt or .cvs file, I get the error:

"Data type mismatch in criteria expression"

Can anyone explain why that happens when I try to export the results? I don't have any problems running the query...
 
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
2K
combo
combo
C
  • Locked
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
410
OzFoxy
OzFoxy
breezett93
  • Locked
  • Question
Field is being rounded in the export process
Replies
17
Views
1K
strongm
strongm
breezett93
  • Locked
  • Question
Brand new lock violations errors all over my database
Replies
11
Views
5K
dhookom
dhookom
MDGarcia
  • Locked
  • Question
Error Could not delete from specified tables 2
Replies
14
Views
1K
MDGarcia
MDGarcia

Part and Inventory Search

Sponsor

Back
Top