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 ...