- Minitab Cookbook
- Isaac Newton
- 221字
- 2021-07-16 12:29:18
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.
推薦閱讀
- 中國國民經(jīng)濟(jì)核算體系修訂問題研究
- 中國新股民必讀手冊(cè)（2015年最新版）
- Magento 2 Cookbook
- 國有企業(yè)經(jīng)濟(jì)責(zé)任審計(jì)實(shí)務(wù)指南
- Mastering System Center Configuration Manager
- 金融保險(xiǎn)集團(tuán)內(nèi)部審計(jì)創(chuàng)新與實(shí)踐
- EViews10.0的應(yīng)用與計(jì)量分析
- 審計(jì)實(shí)務(wù)案例與實(shí)訓(xùn)教程
- OAuth 2.0 Identity and Access Management Patterns
- AO2011實(shí)用手冊(cè)
- Tableau：Creating Interactive Data Visualizations
- 成功通過PMP（第3版）
- 內(nèi)審兵法
- 計(jì)量經(jīng)濟(jì)學(xué)理論與應(yīng)用：基于Eviews的應(yīng)用分析
- 汪博士解讀PMP?考試（第6版）