Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: export through DTS

    Hi Everyone I got another problem every time I try to import data to Sql from Access 2000 it keeps give me an error message that says row 2271. Errors encountered so far in this tabel 1 insert error, column 8 (DOB, DBTYPE_DBTIMESTAMP), status 6: Data overflow. Invalid Character value for cast sepcification.

    anyone got any suggestions

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    What is the record in row 2271?
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    2271

    the same data in 2271 exsist in the rest of the database. columns Category, rehire, firstname..lastname..etc hiredate (date formats date/time)

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I guess, Derrick was asking what is the value of column 8 (DOB) at record 2271. It has to be different vs. let's say record #2270. Is the data type in access also datetime or it's a varchar?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    data

    oh sorry the data in access is date/time data type, not varchar

  6. #6
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Here's where I'm going with this. Give us the CREATE TABLE statement for the SQL Server table you're importing into. Then give use the entire row of data from records 2270 and 2271. We should be able to see what's going on from that easily.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

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