Copy sql server table into access table

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 .it is very urgent..Thanks in advance....

Resmy Ravi · Answer

hi.. thanks for your replay... I need the c# code to do the same.If it is possible please give me the code...

Amit Choudhary · Answer

you can do this by Import/Export wizard of sql server. To repeat the same step no. of time save it as SSIS package and run whenever you want .. Here is the article how to create SSIS package from Import/Export wizard of SqlServer.