上QQ阅读APP看书，第一时间看更新
Opening data from Access using ODBC
Here, we will show the instructions to pull data from a table within Access.
Getting ready
The instructions are left generic to enable us to use a suitable Access database. Try using these with your data.
How to do it…
The following instructions detail the steps for importing data from a database into Minitab:
- Within Minitab, go to the File menu and click on Query Database(ODBC).
- Click on Machine Data Source, and select MS Access Database from the data source list. Then click on OK.
- We can select the drive at the bottom of the next screen, and navigate to the folder containing the database.
- Select the database and click on OK; fill in the username and password as required.
- We will pick a table in the database from the drop-down control and then select the columns required from the selection on the left-hand side.
How it works…
ODBC stands for Open Database Connectivity and is aimed to allow transfer of data between databases independent of operating systems or database systems. Most databases supporting ODBC can be queried this way using Minitab.
Here, Minitab is constructing an ODBC command to ask Access for the data. The command that was sent from Minitab to Access can be seen by going into the History folder.