Import Excel File to Access 2010, 2013 With File Dialog in VBA

Import Excel File into Access 2010, 2013 with VBA File Dialog

I have been working with a lot of excel spreadsheets lately. In most cases, I have found that the most simple approach has been to load spreadsheets into Access tables and slice/dice data with SQL queries. I have one spreadsheet in particular that is standardized and updated daily. By quickly loading and running saved queries, […]

Access 2010, 2013 VBA Run SQL Return Results

Sometimes when developing automation with VBA in Access, it is important to return results from a SQL query string. For simplicity, all examples have been written as Functions. Please feel free to modify as needed. Recordset Selection in VBA | Select One Record There are many reasons why a developer would want to return only […]

Crack Microsoft Word Password Free

So you recently took over a project and as the new lead you need to change some content in a key process document. After you open the document, you find out that it is read only and protected by a password from the last guy who is no longer there… What??? Anyway, I realize that there are […]

Utilities – Open Source Software Reviews

There are an almost infinite amount of open source projects as new ones start every day. Here is a list of open source technologies that I have used and reviewed on this Tech Blog: How to Install Google Chrome on Fedora 18 GRUB Rescue | Repair MBR | Master Boot Record Clonezilla | Disk Cloning […]