Excel Archives | Cloudfronts - Microsoft Dynamics 365 | Power BI | Azure

Tag Archives: Excel

How to convert SQL table into Excel sheet and Excel sheet into a SQL Table

Introduction: Sometimes a user wants to analyze their SQL query results in Microsoft Excel or import existing Excel data sheets as tables in SQL in order to do various data transformations. In both scenarios we can achieve this goal as: Converting Data from SQL table to Excel sheet: Go to tools option on the toolbar … Continue reading How to convert SQL table into Excel sheet and Excel sheet into a SQL Table

Filter Error In Excel While Exporting SSRS Report From D365 CRM To Excel

Posted On October 10, 2018 by Simran Monteiro Posted in Tagged in , , ,

Introduction: Once a User exports a report to Microsoft Excel from a Microsoft Dynamics CRM environment, they may want to further filter the report in Microsoft Excel. Issue: An issue I came across recently was that the report, when exported to Excel, would not allow me to filter in Excel for the first few columns, … Continue reading Filter Error In Excel While Exporting SSRS Report From D365 CRM To Excel

How to split an ‘Address’ column into multiple columns in SSIS

Posted On December 29, 2017 by Simran Monteiro Posted in Tagged in , ,

Introduction: We can split an Address column into multiple columns for Flat Number, Building, Road, City etc. in order to make it easier to process the data. In order to do this, we can use the Derived Column Transformation in SSIS. Steps: In the screenshot below, you can see the Address column has an aggregated … Continue reading How to split an ‘Address’ column into multiple columns in SSIS

SEARCH :

FOLLOW CLOUDFRONTS BLOG :