Type Conversion Failure

I

itchy777

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?
 
J

Jerry Whittle

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;
 

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

Top