I'm using a access database to store my data. I want to export the data in the access database to a excel 2007 file using VB.Net.
Can someone post a code to do the above task. thank you
I'm using a access database to store my data. I want to export the data in the access database to a excel 2007 file using VB.Net.
Can someone post a code to do the above task. thank you
>Exporting from VB.Net to Microsoft Excel 2007. Can someone post a code to do the above task. thank you
Two ways:
1. Use ADO.NET OleDb data provider.
2. Office InterOp API
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.