Retrieving data from linked server : access 97

• jvElecenter

  SSCarpal Tunnel

  Points: 4502

  More actions

  July 25, 2003 at 2:15 am

  #162110

  Hi, I'm linking an access 97 database to my SQL 2000 server.

  Now I want to retrieve data and put it in a table into a database on my SQL. What's the best way to do so ?

  Remark : In that same database there is a table with one field : a counter (= the number of the file). The data I should retrieve from that access database should be equal to that counter (if exists). Then the counter should be added with one.

  Much obliged.

  JV

  
  JV

• David Burrows

  SSC Guru

  Points: 65142

  More actions

  July 25, 2003 at 6:33 am

  #467021

  Does the counter signify a column in a table or part of a table name.

  Off the cuff and not tested you could try

  INSERT INTO sqltable

  SELECT m.*

  FROM accessdatabase...mdbtable m

  INNER JOIN accessdatabase...countertable c ON c.counter = m.counter

  UPDATE accessdatabase...countertable SET counter = counter + 1

  Far away is close at hand in the images of elsewhere.
  Anon.