Displaying 1 result from an estimated 1 matches for "patientdb".
Did you mean:
patient
2004 Sep 29
0
solution for reading access tables into R
...#########################
f>or instance, if
>there is a table named patient in the access file named patient_data
>in my C drive.
You need to set up a DSN for the file using the ODBC program in the
Control Panel. This is the name ODBC uses for your database. Suppose you
call it "patientdb"
Now
library(RODBC)
channel <- odbcConnect("patientdb")
to connect to the database
sqlTables(channel)
to list the available tables
sqlFetch(channel, "patient")
to fetch the table called "patient"
odbcClose(channel)
to close the connection.