Member Avatar for 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...

  • 2 Contributors
  • 1 Reply
  • 83 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for kvprajapati

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.