- 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.
推薦閱讀
- INSTANT Citrix XenDesktop 5 Starter
- 新形勢下中國投入產出核算的變革與實踐
- 中國特色社會主義國家審計制度研究
- 2016年度注冊會計師全國統一考試專用輔導教材（圖解版）：審計
- Salesforce Essentials for Administrators
- 陜西國家統計調查市、縣優秀報告集萃（2006—2015）（上下）
- 企業并購審查中的相關市場界定：理論與案例
- Getting Started with Microsoft Lync Server 2013
- Business Intelligence Cookbook：A Project Lifecycle Approach Using Oracle Technology
- Implementing VMware Horizon 7.7
- Learn Power Query
- 統計學視角下的金融高頻數據挖掘理論與方法研究
- Microsoft SharePoint 2010 Developer’s Compendium：The Best of Packt for Extending SharePoint
- 效益實現管理實踐指南
- INSTANT IBM Lotus Notes 8.5.3 How-to