search for: sqtabl

Calling function "sqlFetch" in library(RODBC) and specifying a character string as 2nd argument, I get an error I don't understand: library(RODBC) channel <- odbcConnect("mydatabase.mdb", case="msaccess") sqlFetch(channel, "mytable") # this works fine tabname <- "mytable"; sqlFetch(channel, tabname) # this gives an error: # Error in

I have probably an old question. I have R.3.0.1 installed in 64 bit windows 7. The odbcConnectExcel in RODBC library does not work. Tried odbcConnectExcel2007 still does not work. Any ideas. Thanks Melissa<-sqlFetch(odbcConnectExcel2007("F:\\Cotton2012\\validation.xlsx"),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(&quo...

..."'Cust Nos$'" [7] "Data$_" [8] "'Diagnostic Pivot$'" [9] "'Historic summary$'" [10] "'MED Supporting Evidence$'" [11] "'MED Supporting Evidence$'Print_Area" > faults <- sqlFetch(channel, sqtable = 'Data', + colnames = FALSE, as.is = TRUE) > faults [1] "HY001 -1040 [Microsoft][ODBC Excel Driver] Too many fields defined." [2] "[RODBC] ERROR: Could not SQLExecDirect 'SELECT * FROM [Data$]'" > faults <- sqlFetch(channel, sqtabl...

...yconn <- odbcConnect("RDATABASE") myconn RODB Connection 6 Details: case=nochange DSN=RDATABASE Description=Database for R UID=Madana_Babu WSID=IBLPN1B049040 Trusted_Connection=Yes NEWDATASQL1 <- sqlFetch(myconne, CampaignDataLarge) Error in odbcTableExists(channel, sqtable) : object 'CampaignDataLarge' not found NEWDATASQL2 <- sqlFetch(myconne, CampaignDataLarge, colnames = FALSE, rownames = TRUE) Error in odbcTableExists(channel, sqtable) : object 'CampaignDataLarge' not found NEWDATASQL3 <- sqlFetchMore(myconne, CampaignDataLarge, colnam...

Your error message was >> d <- sqlFetch(channel, District) > Error in odbcTableExists(channel, sqtable) : > object "District" not found and as you had not defined an object 'District' in that session, it seems perfectly plain. If you want to refer to table "District" you have to give a character string (with quotes), not the name of an R object. If all els...

...ve missed something, i cant see a solution to this on the help list. grateful for any help or pointers simeon # long way library(RODBC) filepath <- "C:/Data/workbook.xlsx" connect <- odbcConnectExcel2007(filepath) tbls <- sqlTables(connect) sheet1 <-sqlFetch(channel=connect,sqtable='sheet1') sheet2 <-sqlFetch(channel=connect,sqtable='sheet2') sheet3 <-sqlFetch(channel=connect,sqtable='sheet3') .. etc close(connect) [[alternative HTML version deleted]]

...t up using the PostgreSQL Unicode ODBC driver, and sqlTables(chnl) works OK and produces a list of tables in the database (they are all in a schema called 'source'). But > seiz.df <- sqlFetch(chnl, 'source.MAIN') fails with the error message Error in odbcTableExists(channel, sqtable) : 'source.main': table not found on channel This occurs even though the table 'MAIN' is listed in schema 'source' in the output of sqlTables(chnl). I am using PostgreSQL version 9.0 and the database is installed on a local server (localhost) on a PC running Windows 7 an...

...t;ABTGRNAMEN") [1] "[RODBC] ERROR: Could not SQLExecute" [2] "S0002 942 [Oracle][ODBC][Ora]ORA-00942: table or view does not exist\n" > # I also tried: > sqlFetch(channel, "TKF.ABTGRNAMEN") Error in odbcTableExists(channel, sqtable) : TKF.ABTGRNAMEN : table not found on channel What am I doing wrong here? It doesn't work with other tables as well; on the other hand, connecting to the table(s) in MS Access works fine using the same ODBC driver. Best regards, Heinrich.

...t;) [...success...] >head(dbdata) Date Asset1 Asset2.... 2009-07-10 0.01 0.02 2009-07-13 0.007 -0.003 ... I'd appreciate any suggestions, Andrew W rm(dbdata) #run query in query analyzer and get date from rtnsUnderscored table #dbdata<-sqlFetch(conn,sqtable="sp_GetModelRtns4OptimizeRangeVer4 5000,'2001-10-01','2009-07-14") #dbdata<-sqlFetch(conn,sqtable="sp_GetModelRtns4OptimizeRangeVer4 5000,'2009-07-01','2009-07-14") dbdata<-sqlQuery(conn,"select * from rtnsUnderscored order by Date asc")...

...ing spectacular: library(RODBC) channel2<-odbcDriverConnect('DSN=xxx') #table names with up to 11 characters still work sqlFetch(channel2, 'abcdefghijk') #table names with 13 or more characters do not sqlFetch(channel2, 'abcdefghijklm') Fehler in odbcTableExists(channel, sqtable) : ?abcdefghijklm?: table not found on channel I do not have any tables with 12 character names, to check where exactly the borderline is. Of course, the table ?abcdefghijklm? exist on the channel, even if I feed it directly t osqlFetch via sqlFetch(channel2, sqlTables(channel2)$TABLE_NAME[...

...This returns a dataframe of 24445 rows and two columns (as intended), but the following command testout <- sqlFetch(channel,"dbo.vwC1198_2006_RawData_With_CMPL_EXCL",colnames = TRUE,rownames = "idSchedule") returns the error message in odbcTableExists(channel, sqtable) : 'dbo.vwC1198_2006_RawData_With_CMPL_EXCL': table not found on channel The value of channel did not change between the two commands. Based on the help files for sqlFetch and sqlQuery, it is not clear to me why one command would find the table and the other would not. I...

Hi, i'm trying to read some data from excel files but it seems that neither xlsReadWrite nor sqlFetch (RODBC) doesn't like the format (Excel 5.0). When i open the file in Excel and save it in a new format Excel 97 -2003 everything works fine. Is it possible to use ODBC connection to open old format files, or i guess i will have to open and save every file in Excel in new format, which

...datafiles[[i]] <- as.matrix(sqlFetch(channel, "Data")) close(channel) } I'm not sure how to alter the code to allow for the fact that some files may not exist - these files should be ignored. Currently, I get the following error Error in odbcTableExists(channel, sqtable) : 'Data': table not found on channel - it however creates an empty file for the first occurance of a non-existing file then stops. I would very much apprepriate any help. Thanks in advance. Dave __________________________________ Get on-the-go sports scores, stock quo...

...ists. The error is coming. Can anyone help? library("RODBC") cdb_cnct <- odbcConnectExcel("Copy of AZIF_DC_GVK_NSCLC_MSALL_287papers_02072012_141450_v1_4.xls") cdb_frame <- sqlFetch(cdb_cnct, "Publication") odbcClose(cdb_cnct) Error in odbcTableExists(channel, sqtable) : 'Publication': table not found on channel rm(cdb_cnct) ________________________________ Notice: The information contained in this electronic mail message is intended only for the use of the designated recipient. This message is privileged and confidential. and the property of GVK BIO...

...o returns back an empty table: > sqlTables(con) [1] TABLE_QUALIFIER TABLE_OWNER TABLE_NAME TABLE_TYPE REMARKS <0 rows> (or 0-length row.names) And sqlFetch doesn't work either: > sqlFetch(con, "PRICES.DB_PRICES") Error in odbcTableExists(channel, sqtable) : 'PRICES.DB_PRICES': table not found on channel Are their other options I should be using with RODBC to pull the data? I have tested the connection in MS Access and can successfully display data (using File->Get External Data...->ODBC->...) Any suggestions would be great,...

...rs gets chunked out to the console. Now what? Here's where I get stuck. There is a table in the test.dbf file called TEST. But, the following tester <- sqlFetch(import_dat,"TEST") blows up - I get the following error message in the console: Error in odbcTableExists(import_dat, sqtable) : 'TEST': table not found on channel OK - so it doesn't seem to find the table TEST in test.dbf. I tried lower-case for TEST (i.e., test), but that doesn't seem to solve the problem. OK, so lets pretend I don't know what the table in test.dbf is called, and use sq...

...1 C:\\USERS\\NUTTERB <NA> Core2012.txt TABLE <NA> 2 C:\\USERS\\NUTTERB <NA> MTGCards.csv TABLE <NA> > sqlFetch(mtg, "MTGCards.csv") Error in odbcTableExists(channel, sqtable) : 'MTGCards.csv': table not found on channel > MTGCards.csv is an export from an MS Access database, and I'm able to get it out of Access, and I'm also able to connect to our Oracle databases. So I'm not sure what it is I'm not getting about reading the text files....

...el <- odbcConnect("TLIAS01", uid="jeff.lindon") > channel RODB Connection 1 Details: case=nochange DSN=TLIAS01 UID=jeff.lindon Trusted_Connection=Yes WSID=TLIJLINDON DATABASE=tliresearch > d <- sqlFetch(channel, District) Error in odbcTableExists(channel, sqtable) : object "District" not found I have checked this problem with our CIO and he confirmed my Data Source configuration is correct (the connection test confirmed that R is able to connect to the database), and that the table really does exist and I have correct permissions (I wor...

...<NA> 5 <NA> 'Scan 11$' TABLE <NA> 6 <NA> 'Scan 12$' TABLE <NA> but the following does'nt work > data<-sqlFetch(channel,scanTables[1,"TABLE_NAME"],rownames=T) Error in odbcTableExists(channel, sqtable) : Scan1$ : table not found on channel whereas this works well: > data<-sqlFetch(channel,"Scan1",rownames=T) > data X-Coord Y-Coord C a C2 Si Mn P S Cr Cr1 1 1648 117896 298.9131 5.558300 4.323123 167.3666...

...4])) Furthermore think about substituting '_' in SQLNAMES to '.' in RNAMEodbcColumns(channel, table)S and vice versa. gsub("[.]", "_", RNAME) gsub("[_]", ".", SQLNAME) (5) in several functions you use if (!any(sqlTables(channel) == sqtable)) ) shouldn't that read if (!any(sqlTables(channel)[4] == sqtable)) ? The above mentioned one-line-only problem with sqlTables() of course breaks this code (6) Some more comments (perhaps due to my ignorance about ODBC, can ODBC write data without sending sql statements?) (6.1) loopin...