Hello everyone,

I would like to know how do we write the code in Visual C# to insert the records present in .mdb file into SQL Server 2000. I am very much in need of this. Can you please respond to me ASAP.

Thanks a lot for helping me.

simple... two connections and two commands.. the first for the sql and the other for oledb (the provider is jet4.0 i think or something like that :)
create an oledbDataAdapter, fill a dataset with the data you want to transfer, and then use the sqlCommand to insert it into the sql database :)..

hope this will help

Nothing is impossible. The impossible only takes longer. "Digital Fortress, Dan Brown"