Import Data types into SQL From Access

Hi

I am trying to import data from a MS access db to a Sql Server 2000 DB however one of the data types is Time (eg 11:15) this will not import into SQl as a Timestamp or even a Smalldatetime. I can import it as text but then I cannont convert itto DateTime later. Does anyone have an Idea how I can overcome this problem…Perhaps a sample SQl I can use.

Thanks