Use ODBC to import data from a database application (such as Access™ or SQL) 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 uses ODBC to import the data for a certain range of dates into Minitab for analysis.
With ODBC, the link is not dynamic, which means that you must execute the command every time that you want the data exchange to happen. However, you can incorporate ODBC queries into a macro, so that you can easily execute the command repeatedly.
To use ODBC in Minitab, you must have the following items on your computer. For more information, contact your database system administrator.
To create a system DSN (machine data source) using the Windows ODBC Data Source Administrator, you must use the ODBC Data Source Administrator that matches the number of bits for your version of Minitab.
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 Minitab converts field types to column types.
|Database field type||Minitab column type||Notes|
|Memo and Text||Text||Minitab truncates values that are longer than 80 characters.|
|Numeric, Currency, and Counter||Numeric|
Minitab converts "Yes" values to 1s.
Minitab converts "No" values to 0s.
Minitab converts true values to 1s.
Minitab converts false values to 0s.