• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 18. Importing Business Data into... > Creating and Using ODBC Queries

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint