Q:

How Do I export data from a Gridview to an Excel sheet

I have a VB.Net application and once the data in the Gridview is populated I require it to be exported to an Excel sheet. Access (.MDB) is the database used.
Please help!
Any awesome links or tips?
Thanks!

A:

I would suggest that you read throught the Gridview and write the info in a .csv file, using ',' (commas) as your separator (delimiter). Then you can just upload that file to your database (probably check if there already is one in the db, then just delete and override)
Hope this helps,
KrizD

