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

Creating and Using ODBC Queries

The acronym ODBC stands for Open Database Connectivity. It's a standard that many database programs and database management systems subscribe to. If you have a data source, such as an Access database, that is what's called ODBC-compliant, then you can import data from it into Excel.

But just because the standard exists and software manufacturers use it doesn't mean that all databases have the same structures. To make sure that these databases can be used in conjunction with other applications the manufacturers provide drivers—in this context, a driver is software that applications such as Excel can use to establish a connection to the database.

When you install Microsoft Office, the setup routine automatically ...

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