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® Excel 2010 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.