ODBC (Open Database Connectivity) is a protocol shared by many applications that lets you import data from database files and systems. With ODBC, you can collect data in a database application such as Access or SQL, then import the data into Minitab to analyze it.
ODBC lets you specify a subset of data to import. For example, a technical support department uses a database to track the number of phone calls, voice mails, and emails per day. The manager can use ODBC to import the data for a certain data range into Minitab for analysis.
With ODBC, the link is not dynamic; you must execute the command when you want the data exchange to happen. However, you can incorporate ODBC queries into a macro, so that you can easily repeat the process.
To use ODBC in Minitab, you need to have the following items on your computer. For more information, contact your database system administrator.
If you have a 64-bit release of Windows and you want to create a system DSN (machine data source) using the Windows ODBC Data Source Administrator, you must use the 32-bit ODBC Data Source Administrator. To start this administrator, browse to C:\Windows\SysWOW64\odbcad32.exe.
Minitab imports database records as rows. Minitab imports the fields in the records as columns. Minitab puts the imported data to the right of any data that is already in the worksheet. The following table shows how field types are converted to column types.
|Database field type||Imported as Minitab column type||Notes|
|Memo and Text||Text||Values longer than 80 characters are truncated.|
|Numeric, Currency, and Counter||Numeric|
"Yes" values converted to 1
"No" values converted to 0
True values converted to 1
False values converted to 0