[R] sqlSave

[Jacques VESLOT]

OK, I finally found what's wrong - "date" column name.


Jacques VESLOT a écrit :

>Dear R-users,
>
>I tried to export a dataframe form R to Access, that way:
>
>library(RODBC)
>channel <- odbcConnectAccess("d:/test.mdb")
>sqlSave(channel=channel, flore, rownames=F)
>odbcClose(channel)
>
>But I always got this error message:
>
>Erreur dans sqlSave(channel = channel, flore, "Florist") :
>[RODBC] ERROR: Could not SQLExecDirect
>37000 -3553 [Microsoft][Pilote ODBC Microsoft Access] Erreur de syntaxe 
>dans la définition de champ.
>
>
>Note that I succeeded in exporting this dataframe into Excel and then 
>import Excel file from Access.
>
>I tried to find where the problem comes from by exporting columns one by 
>one, as follows:
>
>library(RODBC)
>canal <- odbcConnectAccess("d:/test.mdb")
>for (i in names(flore)) {
>cat(i)
>sqlSave(channel=canal, dat=flore[i]) }
>odbcClose(canal)
>
>I could export all columns but one, named "date", which consists of dates.
>
>I tried to export this column as POSIX, as Date and even as character, 
>but without success. I still had the same error message:
>
>dateErreur dans sqlSave(channel = canal, dat = flore[i]) :
>        [RODBC] ERROR: Could not SQLExecDirect
>37000 -3553 [Microsoft][Pilote ODBC Microsoft Access] Erreur de syntaxe 
>dans la définition de champ.
>
>I also tried with varTypes, though I am not sure how to use this 
>argument correctly. I did:
>
>sqlSave(channel=canal, dat=flore, varTypes=c(date="Date"))
>sqlSave(channel=canal, dat=flore, varTypes=c(date="Date/Heure"))
>
>But still the same error message.
>
>Maybe it's in Windows, but I don't understand...
>
>Thanks for helping,
>
>jacques
>
> > R.version
>         _             
>platform i386-pc-mingw32
>arch     i386          
>os       mingw32       
>system   i386, mingw32 
>status                 
>major    2             
>minor    2.1           
>year     2005          
>month    12            
>day      20            
>svn rev  36812         
>language R
>
>______________________________________________
>R-help at stat.math.ethz.ch mailing list
>https://stat.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
>
>  
>