filter data from a linked server (Access DB)

• ckuroda

  Mr or Mrs. 500

  Points: 511

  More actions

  October 17, 2003 at 7:42 am

  #84622

  Hello Everyone,

  I wish to insert name, dob, and ss number into a persons table in a

  customers database from an access table that I have set up as a linked

  server called Customers. My persons table does not allow blank ss numbers,

  but the Customers table ( from a linked server has blank ss numbers. Would

  anyone be able to help me with the where statement to filter out the null

  values from my linked server in the insert query?

  Your help is appreciated.

  Thanks,

  Chieko

• David Burrows

  SSC Guru

  Points: 65143

  More actions

  October 17, 2003 at 3:19 pm

  #478694

  where ss is not null

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