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