Archiv contains scripts for create SQL database a it’s objects for Microsoft SQL Server and simple console .NET application, which imports XML data from XML export of account movements in bank account web interface of Tatrabanka a.s. into created SQL database. Database contains table of transaction categories, which you can use simple categorization of incame and expenses movements. For simplicity database has no relations between tables defined. During financial analysis of last years I missed fast using tool for import XML data with structure provided by Tatrabanka’s account movements XML export feature, so I made this simple .NET application, instead of using of Integration Services of SQL Server, or import XML data directrly into Excel and then import sorted data into SQL database, using SQL Import Wizard.
Manual for installation and usage SQL import and XML export of account movements in Tatrabanka a.s.
Recent Comments