Recent Posts

Home/Recent Posts

SQL Import Wizard Error Importing Excel Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

  Symptoms Using SQL Server 2014 import tool from within the Management Studio to import an Excel spreadsheet this error message appears: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data) The spreadsheet opens fine on the machine using Excel Solution Microsoft Office 64bit Version is installed, but the management studio is 32bit [...]

By | 2015-08-05T15:35:19+00:00 August 5th, 2015|Recent Posts, Uncategorized|0 Comments

Janus CalendarCombo box quirk

As I was working on a new system I encountered problems with the calendar combo field. The date would seeming randomly not fill correctly while other times it would fill fine. I checked to see if it was a problem with certain records or problems in my code but there wasn't, the calendar could fill [...]

By | 2015-04-27T11:23:39+00:00 April 27th, 2015|Recent Posts, Uncategorized|0 Comments

Microsoft Office Automation and .Net

For 15 years I have been using the Office object model, within classic VB and then with .Net. Its never an easy area to write for having to watch for memory leaks, and navigating the complex object model of Word, Excel and Outlook. Another problem, is that of office versions. Now that office has been [...]

By | 2015-04-23T08:44:28+00:00 April 23rd, 2015|Recent Posts, Uncategorized|0 Comments

Visual Studio and Crystal Reports

Back in the mid 90s Crystal Reports was included as part of the Visual Basic Development package. Then it got dropped for a version. Since Visual Studio its releationship with Microsoft's products has been equally fluid. Crystal Reports over the years has given us more problems with deployment that everything else we combined. It was [...]

By | 2015-04-16T11:18:11+00:00 April 16th, 2015|Recent Posts, Uncategorized|0 Comments