search for: tabquot

Displaying 5 results from an estimated 5 matches for "tabquot".

Did you mean: tabquote
2010 Jul 13
2
RODBC and Excel 2010 xlsx
...l 2007 32 bits). But the function odbcConnectExcel2007 isn't able to import .xlsx files now that I have the new version of the Office package. It gives me the following warning message, which make impossible the importing process through sqlFetch: Warning messages: 1: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Nome da fonte de dados não encontrado e nenhum driver padrão especificado (Source name not found and no default driver specified) 2: In odbcDriverConnect(con, tabQuote = c(&quot...
2013 Jul 16
2
Importing data by odbcConnectExcel in 64 bit
...lsx"),sqtable = "Sheet3", + na.strings = "NA", as.is = TRUE) Error in sqlFetch(odbcConnectExcel2007("F:\\Cotton2012\\validation.xlsx"), : first argument is not an open RODBC channel In addition: Warning messages: 1: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) : ODBC connection failed > Melissa&...
2010 Jul 22
1
64 bit use of odbcConnectExcel
...he 32 bit version of R but fails on the 64 bit [both on the same machine, using the same function, importing the same .xls file]. The message from 64 bit R is: Error in sqlTables(channel1) : first argument is not an open RODBC channel In addition: Warning messages: 1: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) : ODBC connection failed I've al...
2011 Dec 04
3
RODBC connect to Excel (64-bit Windows 7)
...ectExcel is only usable with 32-bit Windows # ok this is clear why it doesn't work > channel <- odbcConnectExcel2007("results.xlsx") # this was one of proposals from old R help posts, but it doesn't work for me Warning messages: 1: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) : ODBC connection failed After that a...
2011 May 18
0
XLSM Question
...t packages such as xlsReadWrite and RODBC. Everything is performed on the final versions of addons and R. Additionally, when I tried the RODBC received the following error: > library(RODBC) > con = odbcConnectExcel("C:\\Temp.xlsm") Warning messages: 1: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) : [RODBC] ERROR: state HY000, code -5120, message [Microsoft][ODBC Excel Driver] External table is not in the expected format. 2: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) : ODBC connection failed Many thanks, Alexand...