Results 1 to 2 of 2
  1. #1
    newaccess is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    May 2010
    Posts
    33

    Arrow insert data into oracle linktable from access table

    I have two table (oracle linked table and access table) with same structure except data type in oracle database and access.
    data type convert as below
    oracle number -->access integer
    oracle varchar2(80)-->access text size 50
    there are only tow column. no index and key.
    the error message as
    ODBC - insert on a linked table <TableName> failed
    [microsoft][ODBC Driver Manager] SQL data type out of range(#0)

    How to fix this issue?

    newaccess

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    It depends....
    HOW are you doing the insert??
    A form, manually entered, code, SQL statement??
    If code, what is the code.
    If SQL, what is the statement??

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 10-15-2012, 02:41 PM
  2. Load csv data to Oracle through Access
    By acces2oracle in forum Access
    Replies: 1
    Last Post: 10-24-2011, 02:41 PM
  3. Export table from Oracle to Microsoft Access 2007
    By dba in forum Import/Export Data
    Replies: 1
    Last Post: 02-25-2011, 07:05 AM
  4. Replies: 1
    Last Post: 12-28-2010, 11:24 AM
  5. Importing data from Oracle to access
    By indira in forum Access
    Replies: 3
    Last Post: 11-18-2010, 02:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums