access_export {ImportExport} | R Documentation |
Export multiple R data sets to Microsoft Office Access
Description
Directly connect (and disconnect at the end) with the Microssoft Office Access database using the RODBC package and write one or multiple data sets.
Usage
access_export(file,x,tablename=as.character(1:length(x)),uid="",pwd="",...)
Arguments
file |
The path to the file with .mdb extension. |
x |
Either a data frame or a list containing multiple data frame to be exported. |
tablename |
A character or a vector character containing the names that will receive the tables where the data frame is stored. If it is a vector, it must follow the same order as the data frames in |
uid |
see |
pwd |
see |
... |
see |
Details
Date variables are exported as an integer, they might be converted to character if a character representation in the access database is wanted.
Value
No value is returned.
Note
This function connects and writes on an existing Microsoft Office Access database, but it can't create a new one.
Examples
## Not run:
# x is a data.frame
file<-("mydata.xlsx")
a<- 1:10
b<-rep("b",times=10)
c<-rep(1:2,each=5)
x<-data.frame(a,b,c)
excel_export(x,file,table_names="mydata")
# x is a list
y<-list(x,x[2:3])
excel_export(y,file,table_names=c("mydata1","mydata2"))
## End(Not run)