Results 1 to 7 of 7

Thread: import the table from MS-Access to Sql server 2000 i am facing this error...

  1. 10-18-2006, 04:58 AM #1
    vvenkatesh
    vvenkatesh is offline Registered User
    Join Date
    Oct 2006
    Posts
    19

    import the table from MS-Access to Sql server 2000 i am facing this error...

    Hi,
    When i import the table from MS-Access to Sql server 2000 i am facing this error...
    Error at Destination for Row number 1, Errors encountered so far in this tasl:1.
    Insert error, column 43('OTHours',DBTYPE_DBTIMESTAMP), status6: Dataflow.
    Insert error, column 42('TWorkedHours',DBTYPE_DBTIMESTAMP), status6: Dataflow.
    Insert error, column 41('EBreakHours',DBTYPE_DBTIMESTAMP), status6: Dataflow.
    Insert error, column 38('EmpEarlyByTime',DBTYPE_DBTIMESTAMP), status6: Dataflow.
    Insert error, column 37('EmpLateByTime',DBTYPE_DBTIMESTAMP), status6: Dataflow.
    Insert error, column 34('BreakHours',DBTYPE_DBTIMESTAMP), status6: Dataflow.
    Insert error, column 33('PersonalHours',DBTYPE_DBTIMESTAMP), status6: Dataflow.
    Invalid character value for cast specification.
    Invalid character value for cast specification.
    Invalid character value for cast specification.
    Invalid character value for cast specification.
    Invalid character value for cast specification.
    Invalid character value for cast specification.
    Invalid character value for cast specification.
    Invalid character value for cast specification.
    Invalid character value for cast specification.
    Invalid character value for cast specification.

    Can you guys give me the solutions. Thanks in advance..
    Venkatesh
    imtesh@gmail.com
    Reply With Quote Reply With Quote
  2. 10-18-2006, 08:37 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You have invalid data in the listed columns.
    Reply With Quote Reply With Quote
  3. 10-23-2006, 12:29 AM #3
    vvenkatesh
    vvenkatesh is offline Registered User
    Join Date
    Oct 2006
    Posts
    19

    Thanks... one more issue

    I fix the problem.. thanks for your kind help.. One more issues there that is i cannot able to connect MS-Access data base from the remote system to my local system
    This is the error i faced. Could please help me in this issue?
    Error Source : Microsoft JET Database Engine.
    Error Descriptioin: Could not lock file.
    Context: Error during intialization of the provider.
    Reply With Quote Reply With Quote
  4. 10-23-2006, 11:26 AM #4
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Does SQL Server account has permission to read from your local system?. If not grant that and use UNC to the local location.
    Reply With Quote Reply With Quote
  5. 10-23-2006, 12:09 PM #5
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You have to start sql service with domain account instead of local system account to access remote data file.
    Reply With Quote Reply With Quote
  6. 10-26-2006, 03:51 AM #6
    vvenkatesh
    vvenkatesh is offline Registered User
    Join Date
    Oct 2006
    Posts
    19

    Thanks all...

    Thanks for your kind help...
    Reply With Quote Reply With Quote
  7. 10-26-2006, 04:23 AM #7
    algogocom
    algogocom is offline Registered User
    Join Date
    Oct 2006
    Posts
    2

    Smile

    The question has covered me ever.Thank all your posts and so glad to meet you all.
    Thank you again and wish you have a nice weekend in advance!
    Rgds,
    Algogo.com
    Attached Images Attached Images
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules