Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Linked server between sql server 2005 and access 2010 proplem Expand / Collapse
Author
Message
Posted Saturday, January 26, 2013 5:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, September 14, 2013 4:54 AM
Points: 15, Visits: 35
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

Post #1412011
Posted Saturday, January 26, 2013 10:04 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:19 AM
Points: 2,820, Visits: 3,916
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
Post #1412045
Posted Saturday, January 26, 2013 11:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, September 14, 2013 4:54 AM
Points: 15, Visits: 35
how i can do this by ssis please tell me
Post #1412052
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse