Make table query

  • Thread starter Thread starter Jays
  • Start date Start date
J

Jays

I have text files whic are imported into tables, I have specified that the
datatype is text. when i run a query based on the table it returns the
results, sometimes i will run a make-table query and depending on the
imported file i will get a "data type mismatch" even though they are all
text fields!!
 
I have text files whic are imported into tables, I have specified that the
datatype is text. when i run a query based on the table it returns the
results, sometimes i will run a make-table query and depending on the
imported file i will get a "data type mismatch" even though they are all
text fields!!
Click to expand...

Correct the error in your query. For help doing so, post some information
about the query or the data in it.

Note that MakeTable queries are often problematic, especially when variable
datatypes are involved; a link or import will GUESS, based on the content of
the file, about the appropriate datatype, and can often guess wrong. For
instance, importing US Zip codes (five digit numbers) or telephone numbers may
create an inappropriate Number field. It's often better to pre-create a table
with the desired field types and sizes (don't need 255 bytes for a Zip even if
it's text!), and use an Append query instead.

John W. Vinson [MVP]
 
Back
Top