Copy tables data from sql server to access database

Question

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#...

Mayur Dighe · Answer

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/

Jaganathan Bantheswaran · Answer

Hi Create a DTS package as like mentioned here Then execute that package using C# as mentioned here