18. Exporting Business Data from Excel

Throughout Chapter 17, “Importing Business Data into Excel” you saw various ways to get 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 ...

Get Business Analysis: Microsoft now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.