Read Access Tutorial with Example Access File

yyhuangyyhuang Administrator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, MemberPosts:363RM Data Scientist
edited November 2018 inKnowledge Base

Symptoms

Diagnosis

Solution

1. Download the sample accdb file from herehttps://www.dur.ac.uk/cis/docs/guides/files/access/

and pick the first link to download 'A Sample Database.accdb'

accesssample.png

2. Open the downloaded sample database in Access, here is what I got from M$ Access 2016 in my local computer

The Asset Items table and some Queries/Forms/Reports are available in my Access view

access_screenshot1.png

3. As long as you can view the table from Access, you can load it into RapidMiner studio using 'Read Access' connector

access_screenshot2.PNGaccess_screenshot3.PNG

4. You can also run a query to load Access views, for example, let's copy and paste the query below to RapidMiner Studio

SELECT `Asset Items`.`Asset No`, `Asset Items`.Make, `Asset Items`.Model, `Asset Items`.Acquired, `Asset Items`.Cost, `Cost`/1.22 AS `Ex Tax`, `Cost`-(`Cost`/1.22) AS GST

FROM `Asset Items`;

access_screenshot4.png

Then in the results view, it should return the quried data table:

access_screenshot5.png

5. For more details, please refer to the documentation

http://docs.www.turtlecreekpls.com/studio/operators/data_access/files/read/read_access.html

and the attached RapidMiner process.

Tagged:
    Sign InorRegisterto comment.