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 ...
Get Minitab Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
