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 x have. All names must be different from each others.
uid
see odbcConnect .
pwd
see odbcConnect .
...
see odbcConnect,sqlSave.
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)