sql server query to *.mdb

Question

hi i need some help, i need to create a file in access 2003 running a aplication asp.net (c#) using a sql query, actually i can create a empty file.. but i want create a file using a query from a table on sql server. can anyone help me?
code in zip..

Mahesh Chand · Answer

Once you have .mdb file, you need to open a connection using OleDbConnection and then its executing SQL queries to CREATE TABLE etc.
http://www.c-sharpcorner.com/UploadFile/mahesh/databaseAccessUsingADO11282005062716AM/databaseAccessUsingADO.aspx
http://www.c-sharpcorner.com/uploadfile/mimrantaj/connect-to-access-database-in-C-Sharp-and-ado-net/