[R] RODBC problem

2007-07-06 Thread Bernhard Wellhöfer
Hello, I use a RODBC connection to a MySQL server on a Debian machine. The call to odbcConnect() seems to be ok, but the result of the first sqlFetch(channel,t_studie) retrieves this data frame: [1] [RODBC] ERROR: Could not SQLExecDirect [2] 42000 1064 [MySQL][ODBC 3.51

Re: [R] RODBC problem

2007-07-06 Thread DUPREZ Cédric
@stat.math.ethz.ch Objet : [R] RODBC problem Hello, I use a RODBC connection to a MySQL server on a Debian machine. The call to odbcConnect() seems to be ok, but the result of the first sqlFetch(channel,t_studie) retrieves this data frame: [1] [RODBC] ERROR: Could not SQLExecDirect [2] 42000 1064 [MySQL

Re: [R] RODBC problem

2007-07-06 Thread Bernhard Wellhöfer
:59 AM To: Bernhard Wellhöfer Cc: r-help@stat.math.ethz.ch Subject: RE: [R] RODBC problem Hello, The problem seems to be in the query syntax. Can you show us the query you are trying to perform ? Regards, Cedric -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL

[R] RODBC Problem

2006-11-17 Thread Sumanta Basak
Hi All, I'm using Microsoft Office 2007 Beta version and I have one file in .xlsx format with size 168MB. How can I use odbcConnectExcel in this as this function only supports .xls format? I have huge data containing 603470 rows in a .csv file. Thanks in advance.

[R] RODBC problem

2006-10-20 Thread Wensui Liu
In a mdb table, I have a text field with values of 1, 2, When I use rodbc to read it into R, it becomes numeric. Is it a bug or something? Thanks. __ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read

Re: [R] RODBC problem

2006-10-20 Thread Jerome Asselin
On Fri, 2006-10-20 at 10:25 -0400, Wensui Liu wrote: In a mdb table, I have a text field with values of 1, 2, When I use rodbc to read it into R, it becomes numeric. Is it a bug or something? I don't think it's a bug. This behavior is documented. See ?sqlQuery. Try the as.is=T argument.

[R] RODBC: problem saving a new table in an Excel database

2003-07-21 Thread David Khabie-Zeitoune
Hi I am using package RODBC version 1.0-1 under R version 1.7.1 on Windows XP Pro. I am having problems writing a new table to an (Excel) database using sqlSave. I connect to an empty Excel spreadsheet using odbcConnectExcel (which, I believe, uses the Microsoft Excel Driver DSN). Then I try and

Re: [R] RODBC: problem saving a new table in an Excel database

2003-07-21 Thread Prof Brian Ripley
The driver does not support writing to Excel: did you check? On Mon, 21 Jul 2003, David Khabie-Zeitoune wrote: Hi I am using package RODBC version 1.0-1 under R version 1.7.1 on Windows XP Pro. I am having problems writing a new table to an (Excel) database using sqlSave. I connect to