How to connect from Sqlserver to MsAccess

• karthik M

  One Orange Chip

  Points: 29139

  More actions

  December 31, 2007 at 5:36 am

  #70684

  Inputs are Higly appreciable !

  karthik

• Jo Pattyn

  SSC-Dedicated

  Points: 32413

  More actions

  December 31, 2007 at 5:47 am

  #763675

  Depending on frequency, you can create a linked server for it. The msaccess subforum probably holds the answer.

• Tom Garth

  SSCertifiable

  Points: 6193

  More actions

  January 1, 2008 at 3:36 pm

  #763887

  Modify as required.

  SELECT * FROM

  OPENROWSET(

  'Microsoft.Jet.OLEDB.4.0',

  'C:\Program Files\Microsoft Office\Office12\1033\DBSAMPLE.mdb';'admin';,

  --[Organization Chart Data]

  [Office - Card Details]

  )

  Tom Garth

  Tom Garth
  Vertical Solutions[/url]

  "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
  

• zurikela

  SSC Rookie

  Points: 41

  More actions

  January 4, 2008 at 3:14 am

  #764741

  hello,

  could you help me with to discover the SQL server versions on the network.

  Thanks in advanced.