p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Link Access 2000 to SQL server


Message #1 by "Pamela Bengtson" <pamb@r...> on Tue, 12 Jun 2001 19:19:48
Hello All -



I need to link an Access 2000 table to SQL Server 2000 (instead of the 

other way around, which is more common).  Has anyone done this or knows 

how to do this?   The articles I've found indicate creating a linked 

server in SQL server and using OLE DB to link, but I have not been 

successful in trying this.   I appreciate any and all suggestions.



Thanks!

Pamela

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Pamela Bengtson, Sr. Programmer Analyst

University of Florida, Research and Graduate Programs


  Return to Index