Post reply

OpenRowSet from a network path

  • September 21, 2005 at 3:57 am

    #168861

    Hi i have a situation i am executing the below query.

    I need to input the file from a remote location  or a network path... like \\james\city.xls

    james is a comuter name...

    How can i do this?

    select *

    from OpenRowSet (

        'Microsoft.Jet.OLEDB.4.0', 'Excel 8.0; DATABASE=\\James\City.xls'

        , 'select * from [Sheet1$]'

        )

    Kindest Regards,

    Pavas

    Dream The Dream
    Explore the World
    Experince The Exhilaration

  • September 21, 2005 at 5:20 am

    #591664

    Well, the example works just fine from a local path, so I assume that it should work just fine from a remote as well, providing you have the proper permissions in place etc regarding the servers service account. (Haven't tried with a remote path, though)

    Have you tried it?

    /Kenneth

  • September 22, 2005 at 11:11 pm

    #592471

    This works !

    with back slash \\

    thanks

    Kindest Regards,

    Pavas

    Dream The Dream
    Explore the World
    Experince The Exhilaration

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

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