convert text to time on import

[Matilda]

Hi All,

I am importing from a text file which has separate date and time fields.
Each is stored as digits, 8 for date eg 01012008, and 4 for time, eg 0936.

The date converts without a problem, but the time will not. I have tried
everything, but as I have around 200 files to process, each with 5 time
fileds to be converted, I was hoping there might be a short -ish process. I
am about to try inserting a separator (colon) into the text string, then
re-importing. I'm scared this will work because of the length of time it will
take :-(((

If anyone can see a better way please help.

Many TIA's,

Matilda

 

[Jeanette Cunningham]

Matilda,
It would be quicker to inset a colon after you import.
Import to a copy of your main table.
Use a query to add a colon to the appropriate field.
The query will do it quickly for you.

I'm not sure how you got access to recognize the date string as a valid
date. Did you use CDate?

Jeanette Cunningham