I am importing data via ODBC from a database containg over 100,000 records. In order to shorten the import period each time, I would like to only import records from a certain date. The database usesthe following date format "31/01/2005".

Each time I try to insert a date condition during the import process, I get the following error.

"ODBC Error (ATIOPENRDA ODBC) Invalid Stmt. Incompatible expression salve tyes in condition : 9, 4."

I have tried changing the date format in the query but this does not seem to have any effect.

Try importing a subset of your data from your ODBC source using something other than the date. Look at the date data import in the raw format to see how it is coming across. Then use that format in your SQL import statement.

How this helps.