Last post May 09, 2008 04:09 PM by Mikesdotnetting
May 09, 2008 10:39 AM|Vasu Voice Of Youth|LINK
Here my question is i want to store the data from Access table to excel sheet.
I know the conventional method i.e
creating objects for excel.application;excel.workbook;excel.worksheet;
but this can be happen only when the user has installed EXCEL in his machine.We should not force him to install it.
irrespective of the installation i want to store the data into EXCEL.
Please give me some idea......
May 09, 2008 04:09 PM|Mikesdotnetting|LINK
The conventional method you refer to wouldn't require the user to have Excel on their machine, as ASP.NET runs on the web server, so Excel would need to be installed there. But the user wuold need Excel Viewer at least, otherwise they would not be able
to do anything with the resulting Excel file.
Anyway, writing data to an Excel file is almost exactly the same as writing it to Access. You would use an OleDbConnection and OleDbCommand and the Jet Provider. Here's some samples in VB: