how to get database records from mssql into excel sheet using vb.net.

[mohankumar554]

hi,
how to get database records from mssql into excel sheet using vb.net.
if i click on button and open the excel sheet enter the data and the data is stored in database in the form of records...

[__avd]

Here are some steps:

1. Open Excel document using MS-Office API.
2. Open MySql Database connection.
3. Read one after one cell and form a record.
4. Prepare a command object.
5. Execute the query.
6. Go to step 2 till excel sheet has data.

If you are having source code of the same problem, please post your code here and also tell us about your progress.