Category Archives: Working With the XML Data

Analyzing Bank File Conversions XML Data Files using Power Query and PowerPivot

In a previous post, I showed how to use the Bank File Conversions App for Excel 2013 (BFC) to: convert BAI Version 2 and BTRS files, set the data in tables in Excel 2013, add them to the Excel Data Model … Continue reading

Posted in Bank File Conversion, Working With the XML Data | Tagged , , , , | Comments Off on Analyzing Bank File Conversions XML Data Files using Power Query and PowerPivot

Storing Bank File Conversion XML Output in SQL Server

The purpose of this post is to give users (or prospective users) an idea of the benefits of storing their bank data in SQL Server (2005 or greater) as an XML data type. In particular converting BAI and BTRS files … Continue reading

Posted in Apps for Excel, Bank File Conversion, Working With the XML Data | Tagged , , | Comments Off on Storing Bank File Conversion XML Output in SQL Server