Post reply

How to connect from Sqlserver to MsAccess

  • December 31, 2007 at 5:36 am

    #70684

    Inputs are Higly appreciable !

    karthik

  • 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.

  • 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

  • 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.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply