Results 1 to 2 of 2

Thread: Import of Data from Access DB

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member Jonny1409's Avatar
    Join Date
    Mar 2005
    Posts
    308

    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.
    Attached Images Attached Images  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width