Category Archives: Microsoft Office

C# Open Excel with Read Only access

This short blog shows you how to open Excel with Read Only access because it is protected by password. When you read this blog Write Excel file to text file with any delimiter (https://chanmingman.wordpress.com/2011/10/10/write-excel-file-to-text-file-with-any-delimiter/). You will see a line //Open … Continue reading

Posted in .Net, Community, Computers and Internet, Microsoft Office | Tagged , , , | Leave a comment

SSIS Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered

This short blog shows you how to resolve another not so meaningful error message that you will encounter if your SSIS package is connecting to Excel. When you look at the error message below then what action should you take? … Continue reading

Posted in .Net, Community, Computers and Internet, Microsoft Office | Tagged , , | Leave a comment

SSIS Read Excel Text value become NULL

The short blog shows you how to resolve the problem when you use SSIS to import Excel file but the Text value become NULL value. I found a link to add IMEX=1 to resolve SSIS to import Excel file but … Continue reading

Posted in .Net, Cloud, Community, Microsoft Office | Tagged , , , , | Leave a comment

Migrate from Docs.com to OneDrive

This short blog is showing you how to migration from Docs.com to OneDrive. If you are a Docs.com users like me then unfortunately if should receive an email to notify you Docs.com is going to close down on 15 December … Continue reading

Posted in .Net, Cloud, Community, Microsoft Office | Tagged , , | Leave a comment

An error has occurred while connecting small: Unrecognized database format ‘ small.xlsx

This short blog is showing to how to resolve the error from SSIS saying “Unrecognized database format” when you connect the Microsoft Access 12 Database Engine to Excel file. One of the major reason is you did not put Excel … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office | Tagged , | Leave a comment

Install Visual Studio 2017

This short blog walk you through the installation of Visual Studio 2017. Run mu_visual_studio_enterprise_2017_x86_x64_10049783.exe from the offline installer (here is how you get the offline installer https://chanmingman.wordpress.com/2017/03/11/create-visual-studio-2017-offline-installer/). For this installation, I choose .NET desktop Development, Desktop development with C++, ASP.NET, … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office | Tagged , , , , , | Leave a comment

Create Visual Studio 2017 offline installer

Good or bad news, Visual Studio no longer comes with ISO file for download in MSDN. You need to run the command in command prompt to get your own Offline Installer. The instruction link is below. https://docs.microsoft.com/en-us/visualstudio/install/create-an-offline-installation-of-visual-studio There are some … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office, Office 365, sharepoint | Tagged , , , , , , | 1 Comment