Displaying 5 results from an estimated 5 matches for "tabquote".
Did you mean:
bquote
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("...
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&l...
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 als...
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 as...
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,
Alexandr...