Building a Full CRUD Application in Excel with VBA and SQL Integration
Presented by: Derek Mulhausen
In this talk, we will build a full application from scratch in Excel to store customer discounts in Excel. We will start with recording a macro to quickly prototype some of our actions and then dig into the underlying code to polish the formatting and produce a product that can be put into production. Through this process we will link to a SQL Express database and learn how to programmatically build form controls and place them on a worksheet.
Basic knowledge of SQL is recommended but not required.
Excel with VBA(Windows is best as VBA for Excel on a Mac has some limitations)
SQL Server Express