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...
mohankumar554 -3 Junior Poster in Training
kvprajapati 1,826 Posting Genius Team Colleague
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.