Linked server between sql server 2005 and access 2010 proplem

  • Hi guys i want to make linked server between sql server 2005 and office 2010. (I try to access The Microsoft Access database from SQL server)but sql server 2005 connected to domain but Microsoft access work as work group computer not connected to domain . is possible to connect between each others.

    what i write in linked server ,provider,,datasource

    thanks

  • why cant u use SSIS ? it provide great heterogenous environment

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • how i can do this by ssis please tell me

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

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