Read Access records

[bobfin]

Within a T-SQL script in SQL Server 2000, is there a way to read records in an Access table? The Access database is on a network drive (O:\Npv\Npv.mdb) and the table is called tblProposals. I want to insert seelcted fields into an SQL table.

 

[FoFa]

You can link the Acces DB to your sql server. You can use DTS to transfer data. Depends if it is a one time thing or on going.