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 ...
Get Business Analysis with Microsoft® Excel, Second Edition 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.
