Posted by: Craig Hatmaker
development, excel, Microsoft Excel, ms query, odbc, sql, vba
When you start MS Query the first thing it asks for is the “Data Source” name. A “Data Source” name is required. At a minimum, a “Data Source” name points MS Query or ODBC to a driver that understands the application’s standards (such as Oracle, DB2, Access, Excel, or MS SQL Server) that your data conforms to.
If you don’t see your required database in the list, you can create it by selecting <New Data Source> and clicking OK. That brings up the “Create New Data Source” dialog.
Step 2 is perhaps the most daunting. Sometimes there are more than one driver listed that support your database. In that case, it usually doesn’t much matter which one you choose. Sometimes there are no drivers that support your database. In that case, you need to load that database’s ODBC driver on your PC.
If you don’t know where to find your ODBC driver, first contact your DBA or Systems Administrator. If they don’t have it, search the database provider’s website under product support for driver downloads. If it’s not there, contact the database provider’s sales or support team. If all else fails, Google your database name with “ODBC driver” to see if someone else provides it. I have found a few old, non-relational databases with third party ODBC drivers for sale; but, the dominant database providers don’t charge. Microsoft includes theirs and several once prominent PC databases with their operating systems. Oracle’s is freely available from their website. IBM’s comes with their PC client or server CDs. Several powerful free databases such as mySQL give the driver away.