Post reply

Date/Time 00:00

  • April 19, 2007 at 1:49 am

    #103343

    Hi,

    I have a table in Access, with date/time data type field and format "00:00". That data type is not combatible with Sql and i have failed to import the table due errors. I am thinking that the proper way to do this is to make the table manually and then import the table. My problem is that i don't know the data type for that field and how to make the field behave like it used to. I was just typing 2301 and it was storing 23:01

    Thanks

     

     

     

     

  • April 19, 2007 at 3:46 am

    #701358

    A datetime is really a 4 byte datatype. Don't rely on formatting.

    If you are worried add a single ":00" for seconds trailing the column.

     

    N 56°04'39.16"
    E 12°55'05.25"

  • April 19, 2007 at 7:50 am

    #701435

    What was the error you recevied as I have never had a problem with importing Access [Date/Time] into SQL Server datetime datatype. Or are you using text in Access with a format? If so then on the transform option of the screen that shows Source / Desitnation / Tranform press the button under the Transform and then on the new dialog switch to the Transformation tab and use a transformation script to alter the incoming data to fit.

  • April 19, 2007 at 11:36 pm

    #701630

    Newbie me…!  

     

    The error was generating by null values in records. I edit the null values and the error is gone.

     

    Thanks all of you for your response

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply