Type Conversion Failure

[Guest]

I'm importing a txt file into a new table. I am getting a Type Conversion
Failure on four date fields of one record. This is happening on one record
out of over 150,000 records. When I look at the data, in the table after
importing the data looks fine.

Any ideas?

 

[Guest]

If it's only one record, find and fix it before importing! ;-) It's only
150,000 lines to look through.

Are you sure that this record is being imported? Access tends to throw away
records that won't import cleanly.

One option is to import the data into a created with the field as text
instead of date/time. Then use the IsDate function in a query to see if any
of the records show up as bad. Something like below:

SELECT tblDatesText.test_date, IsDate([test_date]) AS NotDate
FROM tblDatesText
WHERE IsDate([test_date])=False;