Post reply

Data Overflow error

  • August 19, 2005 at 2:07 pm

    #66797

    Does anybody tried to import a long time field from access into sql server 2000? when I try to import a field like "9:30:50 AM" to sql server, I got a errror:error at destination for row number 1 .... data overflow. invalide character value for case specification. How can I solve this problem?Thanks!

  • August 19, 2005 at 2:14 pm

    #583710

    Do you have a date linked to that time??

  • August 19, 2005 at 2:22 pm

    #583712

    is the column varchar or datetime??

  • August 19, 2005 at 2:29 pm

    #583713

    try importing as a varchar() field.

    Also what are the biggest and smallest dates in that table?

  • August 19, 2005 at 2:44 pm

    #583715

    not quite... changing to varchar just makes the transfer work.. you still should use datetime if possible, that's why I wanted to know about the range of dates.

  • August 19, 2005 at 2:57 pm

    #583716

    without a date attached to it?

  • August 19, 2005 at 3:07 pm

    #583718

    Try merging them into a single field when doing the transfer in a datetime field, it should work... or transfer them separatly and merge them afterwards.

  • August 19, 2005 at 4:02 pm

    #583726

    Without knowing how you are doing the import, it is difficult to respond.  I have 2 thoughts:

    1) If you store the date as text in your MDB, you will have to Cast/Convert it to DateTime as you do the import.

    2) Access use "#" to delinieate date/time, but SQL Server uses single quotes.  Perhaps your problem has to do with SQL Server receiving a "#" character instead of single quotes?

    How are you doing the import procedure????

Viewing 8 posts - 1 through 8 (of 8 total)

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