If You’re a VBA Developer You should know what best practices is to export data to MS Excel. Two expressions summarize it; Microsoft ActiveX Data Object Library and CopyFromRecordset. However, if You’re a .NET developer and face a situation where You must find a solution to export data to...
VSTO & .NET & Excel
Mon, Jan 30 2012
Filed under: Filed under: COM Add-ins, Tools, .NET & Excel, VSTO & Excel, SQL Server, Developer sites, Excel, SQLite, Valentina DB, Valentina Office Server
Since 2004 I have been running ExcelKB where I have posted articles about Excel and .NET/VSTO on a regular basis. Overall it has had a quite a number of visitors and also a great number of page views.
Under all these years I have paid for the service of using a Microsoft SQL Server database to handle...