I have used the DTS utilities to import from Access and this has been mostly sucessful. My real issue is that in one table in access i was utilizing Date/Time fields set to a format of SmallTime,ie fields “TimeIn” and “TimeOut”. Further, I also used an update query in access to calculate the time between the In and Out. The SQL table/field definition of “smalldatetime” does not seem compatible for the import of existing data and the update query simply reports an Overflow. Any suggestions????
Regards
toncc