Microsoft Access Question 2?

I need to import text data into an Access database table.

But, one of the fields in the table is a date/time format.

I use that particular field to do a time/date calculation.

Unfortnately, whenever I do a data import that field is not recognized because of its time/date format/

If I change the field's setting to text I can import the datea flawlessly.

Does any one have any suggestions how I can solve the problem so that the table accepts my text import seamlessly?

All of the other fields in the table are ok.

Thanks for your help.