trouble exporting time from access to sql server

[jayne]

Hi,

I've been having this problem. I'm trying to export a
series of date and time from ms access to sql server but
can only manage to export the date but not the time as the
date and time are two separate columns. The error that I
receive after execution in sql server is that there is
an "invalid character value for cast specification".

Please help, thanks.