Excel User Group

Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Sign in | Join | Help

XL-Dennis's Blog » All Tags » SQL Server » SQLite (RSS)

Browse by Tags

XL-Dennis's Blog

Home

Syndication

Recent Posts

Tags

Archives

Clean Up!

As part of my maintenance, in order to keep the computer fresh, is to regular run the built-in tool Free up disk space. The tool is accessible via the following commands: Start Button > Control Panel > System and Security > Administrative Tools > Free up disk space After running it the following dialog is [...] Read More...

Published Sun, Mar 03 2013 3:52 PM by VSTO & .NET & Excel

Filed under: COM Add-ins, .NET & Excel, VSTO & Excel, SQL Server, Excel, SQLite, Valentina DB, Apps for Office, Database, Spreadsheet components
Best Practices Export Data to Excel

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 MS Excel then there is a [...] Read More...

Published Mon, Jan 01 2012 7:43 AM by VSTO & .NET & Excel

Filed under: COM Add-ins, Tools, .NET & Excel, VSTO & Excel, SQL Server, Developer sites, Excel, SQLite, Valentina DB, Valentina Office Server

Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.