Category Archives: Microsoft Office

Outlook display receiver instead of sender in folder

This post show you how to change the Outlook folder to display receivers instead of senders. This is for Outlook 2013. Go to VIEW tab. Click View Settings. Click Columns. Select From in Show these columns in this folder. Click … Continue reading

Posted in Microsoft Office, Office 365 | Tagged , , | Leave a comment

Convert Excel Sheet to csv file for SSIS

You can use the code below to concert Excel to csv. You need to add the Microsoft.Office.Interop.Excel. The reason I am doing this is, I have been facing many issues to read the Excel from SSIS to the database for example, … Continue reading

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

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