Source database ORACLE data to insert in Access db

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  February 22, 2010 at 6:38 am

  #73487

  Hi,

  I want Query for update data in MSACCESS db from oracle db.

  Could you give me, syntax or script.

  SELECT *

  FROM OPENROWSET('ORAOLEDB.1', 'SERVER=IPAddress;UID=username;PWD=password', 'SELECT * FROM Tablename')

  i want fetch data from oracle database. to update MSaccess db How can modified above query based on msaccess db?

  Thanks for Help

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  February 23, 2010 at 4:05 am

  #1123519

  I have tired below query, but it is not hope

  msaccess Table name - NIR_INPUT

  oracle table name - LIMS_NIR_RESULT

  UPDATE NIR_INPUT T1 SET T1.SAMPLE = (SELECT T2.SAMPLE

  FROM LIMS_NIR_RESULT T2 WHERE T1.SAMPLE_ID = T2.SAMPLE_ID);

  Error.

  Invalid Memo, OLE, or Hyperlink Object in subquery 'T2.SAMPLE'

  Can anyone suggestion pls.

  Thanks