How to Export data from a Grid to MS Access.?

[Robins Antony]

Hi Friends,

Does anybody know How to Export data from a GridView to MS Access using C #.

Any help would b greatly appreciated.

Regards

Robins

[serkan sendur]

if you have a predefined database structure, create the ms access file on the server, fill it with your data as normal database operation, then load it to the client when the client requests the file.

[Robins Antony]

Hi
Thank u so much for u r reply.
How to create ms access file on the server?.is it using ADOX ?

I want to export the data in the Grid view to ms access format & save it as a .mdb file whenever the client click the button 'Export to MS Access' like exporting to Excel sheet.

Thanks in Advance

Robins