DATA MINING Desktop Survival Guide by Graham Williams
Desktop Survival Project Home List of Figures List of Tables Data Mining Data Mining Data Mining with Rattle Introduction Data Transform Explore A Model Building Framework Unsupervised Modelling Two Class Models Multi Class Models Regression Models Text Mining Evaluation and Deployment Moving into R Troubleshooting R for the Data Miner R Data Graphics in R Understanding Data Preparing Data Building Models Evaluating Models Algorithms Apriori Bagging Bayes Classifier Boosting Cluster Analysis Conditional Trees Hierarchical Clustering K-Means K-Nearest Neighbours Linear Models Logistic Regression Neural Networks Support Vector Machines Text Mining Open Products AlphaMiner Borgelt Data Mining Suite KNime R Rattle Weka Closed Products C4.5 Clementine Equbits Foresight GhostMiner InductionEngine ODM Enterprise Miner Statistica Data Miner TreeNet Virtual Predict Appendicies Glossary Bibliography Index

Access

MS/Access databases, on MSWindows, can be directly accessed through ODBC with an odbcConnectAccess. A database can be querired for a list of all tables available, using sqlTables, and imported with sqlFetch or sqlQuery. We can then directly save the table as an R object fo simpler loading into R at a later time:

> library(RODBC)
> channel <- odbcConnectAccess("h:/sample.mdb")
> sqlTables(channel)$TABLE_NAME
> clients <- sqlFetch(channel, "Clients")
> odbcClose(channel)
> save(clients, file="clients.RData")

Support further development through the purchase of the PDF version of the book.
Brought to you by Togaware.