- 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ì)核算體系修訂問題研究
- 中國新股民必讀手冊（2015年最新版）
- 審計全流程技術(shù)操作實務(wù)指南
- 資本的眼睛
- 汪博士詳解PMP?模擬題（第4版）
- 國有企業(yè)經(jīng)濟(jì)責(zé)任審計實務(wù)指南
- 基于價值增值的治理導(dǎo)向型內(nèi)部審計研究
- Splunk：Enterprise Operational Intelligence Delivered
- 讓財報說話：世界500強(qiáng)CFO帶你輕松讀財報（鮮讀版）
- 審計實務(wù)案例與實訓(xùn)教程
- 陜西國家統(tǒng)計調(diào)查專題研究集萃（2006—2015）
- Tableau：Creating Interactive Data Visualizations
- 風(fēng)險導(dǎo)向?qū)徲嫓?zhǔn)則實施效果研究
- Programming Microsoft Dynamics NAV（Fifth Edition）
- 看穿一切數(shù)字的統(tǒng)計學(xué)