Category Archives: Microsoft Office

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

Office 2013 application cannot run Office App Store application

This blog is specifically for Windows 7 32 bit and Office 2013 32 bit. I have this problem when my Windows 7 32 bit, cannot do Windows Update. That also means MS Office 2013 will not be updated. You need … Continue reading

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

Microsoft Power BI vs Qlik vs Tableau 2017

Gartner 2017 reports shows Tableau, Qlik, and Microsoft are the leader in Business Intelligence and Analytics Platforms. The full Gartner url is at the bottom. The Gartner link will be expired in sometime later, that was my experience with Gartner … Continue reading

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