Business Analysis with Microsoft Excel, Fifth Edition

18

Exporting Business Data from Excel

In This Chapter

Using VBA to Update an External Database

Editing the Record’s Values

Using With Blocks

Adding New Records to the Recordset

Choosing to Use ADO

Throughout Chapter 17, “Importing Business Data into Excel,” you saw various ways to get financial data into Excel workbooks from websites, databases and other applications. This chapter shows you how to reverse the process: to move data that you have in an Excel workbook to a database.

Using VBA to Update an External Database

The reasons you may want to move data from an Excel workbook to a database involve both user convenience and technical issues. Many people find an Excel worksheet a familiar, even intuitive work environment, but they feel at ...