Loading

Copy tables data from sql server to access database

Resmy Ravi

Hi..

I am doing a project in C# with sql server as back end.In my project i need to copy the tables data in to access table whose structure is same as that of the sql server database.How can i Possible it.Please give me the code .I can simply copy tabales data from access to sql server using bulkCopy.But it is not possible to copy from sql server to access.Ther is problem in the query.Have to do this programmetically.Please give me the code in C#...

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mayur Dighe15y ago
Hey Resmy Ravi,

        You can do it,

        Just need to use simple queries appropriately for each of Back End DataBase for transferring data programmetically.

This link will helpful to you....
        http://www.vbdotnetheaven.com/UploadFile/ea36c5/6914/
0
Jaganathan Bantheswaran15y ago
Hi,

Create a DTS package as like mentioned here

Then execute that package using C# as mentioned here
0