Time Conversion from Text in Access

[Chip193]

I have an excel worksheet that is sent to me on a regular basis for analysis.
I do the analysis in Access. Both are from the Office 2000 product.

When the times are sent to the Excel database, they are sent as text in the
form 0123 (24 hr clock). I need to convert them to times that Access can
understand.

I can change them in Excel using the TIME command, but the command provides
different output in Access. If I try to change it in Excel, it will cause
over 125,000 computations to be done and would need to be redone each week.

Any ideas?

Thanks.

 

[KARL DEWEY]

Import data into a table that has the required sturcture plus a datetime
field. Run an update query on the datetime field like --
Left([YourTextTime],2) & ":" & Right([YourTextTime],2)

 

[Van T. Dinh]

TimeSerial(Left(TimeText, 2), Right(TimeText, 2), 0)

should do.