1 Attachment(s)
Import of Data from Access DB
Hello,
I'm trying to import some data from a table in an Access Database into my SQL Server.
It's one field I'm having a problem with and I don't know how to get round it.
Basically the field in Access is called "DueToStartWorkAt" and is a "Date/Time" type field.
It shows values as "09:00:00" etc.
When I try to import this table into SQL, I get the attached, and I don't know how to get round it.
Re: Import of Data from Access DB
Is the cooresponding SQL Server field that same field type?