Introduction to database connections in Excel for efficient risk control – Part 4
Part 4: How to insert data from an excel sheet into a database table In previous articles we discussed how to connect to the database and...
top of page
NEWS
Introduction to database connections in Excel for efficient risk control - Part 3
Part 3: Database connections in Excel – Tricks with Oracle In the article “Introduction to database connections in Excel for efficient...
Introduction to database connections in Excel for efficient risk control - Part 2
Part 2: Creating dynamic queries in Excel with VBA In the last article, we introduced how to use the EXCEL interface to connect EXCEL...
Introduction to database connections in Excel for efficient risk control - Part 1
Part 1: How to make automatic reports Introduction: Microsoft Excel and SQL database are the basic tools of data analysis. Regular tasks...
bottom of page