O'Reilly logo

Business Analysis with Microsoft® Excel, Second Edition by Conrad Carlberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Updating the Database from Excel

Throughout this chapter, you have learned various ways to get data from Web sites and databases into Excel workbooks. There are times when you want to reverse the process: to move data that you have in an Excel workbook to a database.

The reasons to do so have to do with both user convenience and technical issues. There are many people who find an Excel worksheet a familiar, even intuitive work environment, but feel at a complete loss when working directly with a database program.

Many database programs, of course, can present information to the user in a grid that looks much like an Excel worksheet, with rows and columns. But in a technical sense the tables are very different. In a database program such as Microsoft ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required