search for: table_schem

...s include spaces, e.g. "Scan 1","Scan 2" etc. If I use RODBC, I get back something like this > channel<-odbcConnectExcel(fileName) > tables<-sqlTables(channel) > scanTables<-tables[c(grep("Scan",tables[,"TABLE_NAME"])),] > scanTables TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 16 <NA> 'Scan 1$' TABLE <NA> 4 <NA> 'Scan 10$' TABLE <NA> 5 <NA> 'Scan 11$' TABLE <NA> 6 <NA> 'Scan 12$' TABLE <NA>...

...ied 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 sqlTables instead: table_list <- sqlTables(import_dat) When I then enter table_list in the console, I get [1] TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS <0 rows> (or 0-length row.names) Meaning, what? It almost seems that its telling me there is nothing in test.dbf. Well, there definitely is (I can open it up in Excel - shudder), but, perhaps it is unable to recognize whats there. Suggestions? Apologies if...

...ng a connection named con I did the following: > con RODBC Connection 3 Details: case=nochange DBQ=c:\temp\test.xls DefaultDir=c:\temp Driver={Microsoft Excel Driver (*.xls)} DriverId=790 MaxBufferSize=2048 PageTimeout=5 > tbls <- sqlTables(con) > tbls TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 c:\\temp\\test <NA> Sheet1$ SYSTEM TABLE <NA> 2 c:\\temp\\test <NA> Sheet2$ SYSTEM TABLE <NA> 3 c:\\temp\\test <NA> Sheet3$ SYSTEM TABLE <NA> Everything seems to be fine. Then I did >...

...RODBC Version 1.0-3, R Version 1.7.1, Windows XP, Oracle8 ODBC Driver Version 8.1.6.4.0: > library(RODBC) > channel <- odbcConnect(dsn="PAV32", case="oracle", believeNRows=FALSE) > # ok, this was succesful > x <- sqlTables(channel) > x[37, ] TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 37 <NA> TKF ABTGRNAMEN TABLE <NA> > # ok, so the table I am looking for ("ABTGRNAMEN") is there, but: > sqlFetch(channel, "ABTGRNAMEN") [1] "[RODBC] ERROR: Could not SQLExecute"...

..."Seasson" "TimeH" "Day" "Holiday" [7] "Corte optimo" "Corte diario" Y si obtengo los nombres de la tabla SQL: sqlColumns(conexion1, "AUXILIAR") TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME OS MKOnline dbo AUXILIAR Date OS MKOnline dbo AUXILIAR Time OS MKOnline dbo AUXILIAR Seasson OS MKOnline dbo AUXILIAR TimeH OS MKOnline dbo AUXILIAR Day OS MKOnline dbo AUXILIAR Holiday OS MKOnline dbo AUXILIAR Corte optimo OS MKOnline dbo AUXILIAR Corte diario Los nombres...

...oblem I am having with RODBC? There's an Excel file I am trying to read from, it has one sheet named 'nameclass'. Thanks in anticipation. Vishal Belsare > library(RODBC) > con = odbcConnectExcel(file.choose()) > tbls <- sqlTables(con) > tbls TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 T:\\data\\in\\nameclass <NA> nameclass$ SYSTEM TABLE <NA> > qry = paste("SELECT * FROM '",tbls$TABLE_NAME[1],"'",sep="") > result = sqlQuery(con,qry) > result [1] "[RODBC] ERROR: Could not S...

...$ $ # This doesn't work $ # Connect to an previously non-existent Excel file $ out <- odbcConnectExcel2007("test.xlsx", readOnly=FALSE) $ test <- data.frame(x=1:10, y=rnorm(10)) $ sqlSave(out, test) $ sqlTables(out) TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 C:\\Documents and Settings\\G69974\\My Documents\\test.xlsx <NA> test$ SYSTEM TABLE <NA> 2 C:\\Documents and Settings\\G69974\\My Documents\\test.xlsx <NA> test TABLE <NA> $ sqlFetch(out, "test&q...

...ying to import data directly from an excel spreadsheet using the RODBC package. I am getting the following error messages, wondering if anyone can help me with it?   > connection = odbcConnectExcel('D:\\R files\\TestData.xls') > tables = sqlTables(connection) > tables    TABLE_CAT TABLE_SCHEM  TABLE_NAME TABLE_TYPE REMARKS 1 D:\\R files\\TestData        <NA> '30092007$'      TABLE    <NA> 2 D:\\R files\\TestData        <NA> '30092008$'      TABLE    <NA> 3 D:\\R files\\TestData        <NA> '31032007$'      TABLE    <NA> 4 D:\\R...

channel <- odbcConnectExcel("nuova tabella terapia occupazionale mod.xls") > ## list the spreadsheets > sqlTables(channel) TABLE_CAT TABLE_SCHEM TABLE_NAME 1 c:\\TABELLE DEFINITIVE\\nuova tabella terapia occupazionale mod <NA> 'emi tot 2006 OAI_60g TO FU1$' 2 c:\\TABELLE DEFINITIVE\\nuova tabella terapia occupazionale mod <NA> 'emi tot 2006 OAI_60g TO FU2$' 3 c:\\TABELLE DEFINITIVE\\nuova t...

...schema? The Oracle database I am using has a table by the same name in two different schemas. This creates problems in sqlUpdate because to sqlUpdate there are duplicate columns. The following is part of the output of sqlColumns: sqlColumns(eids, "TEST_ARTCL_INST")[,1:4] TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME 1 EIDS TEST_ARTCL_INST CHANNEL_ID 2 EIDS TEST_ARTCL_INST ARTICLE_TEST_ID 3 EIDS TEST_ARTCL_INST CHANNEL_OLD_ID 4 EIDS TEST_ARTCL_INST FREQ_FM_CNT 5 EIDS...

...ique column > I am using R 2.12.0(2010-10-15) Using Microsoft access 2003. Furthermore, the sqlColumns(accesChannel , "USArrests") returns the following information > sqlColumns(accesChannel , "USArrests") TABLE_CAT TABLE_SCHEM TABLE_NAME 1 C:\\ARTIFICALDESKTOP\\CurrentDownloads\\termstrc\\data <NA> USArrests 2 C:\\ARTIFICALDESKTOP\\CurrentDownloads\\termstrc\\data <NA> USArrests 3 C:\\ARTIFICALDESKTOP\\CurrentDownloads\\termstrc\\data <NA> USArrests 4 C:\\ARTIFICALDESKTOP\\Curre...

...ut occasionally I do get data files large enough in CSV format RODBC could be helpful) . I set up a DNS called "Text Files" and then ran the following code in R > library(RODBC) > mtg <- odbcConnect("Text Files") > sqlTables(mtg) TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 C:\\USERS\\NUTTERB <NA> Core2012.txt TABLE <NA> 2 C:\\USERS\\NUTTERB <NA> MTGCards.csv TABLE <NA> > sqlFetch(mtg, "MTGCards.csv...

...vogellocaties_copy.mdb") > sqlQuery(channnel = MDB, "SELECT gebiedscode FROM ganzengebieden;") Error in sqlQuery(channnel = MDB, "SELECT gebiedscode FROM ganzengebieden;") : first argument is not an open RODBC channel > sqlTables(channel = MDB) #truncated output! TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 13 <NA> ganzengebieden TABLE <NA> > sqlFetch(channel = MDB, 'ganzengebieden') #makes R crash > sessionInfo() R version 2.15.2 (2012-10-26) Platform: i386-w64-mingw32/i386 (32-bit) locale:...

Hi folks, Win 7 64bit R 2.12.0 32bit Problem in reading Excel spreadsheets (the text file, research_databaseI.xls, was download on Internet) > data=odbcConnectExcel(file.choose()) > sqlTables(data) TABLE_CAT TABLE_SCHEM 1 C:\\Users\\satimiswin764\\Documents\\research_databaseI <NA> 2 C:\\Users\\satimiswin764\\Documents\\research_databaseI <NA> 3 C:\\Users\\satimiswin764\\Documents\\research_databaseI <NA> 4 C:\\Users\\satimiswin764\\Documents\\research_databaseI &l...

Hello, I am trying to play with RODBC library and Excel Files. In my file (doubs.xls) there are 2 spreadsheets: > library(RODBC) > connection<-odbcConnect("Excel Files") > sqlTables(connection) TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 F:\\Th?se\\R\\Doubs NA Faune$ SYSTEM TABLE NA 2 F:\\Th?se\\R\\Doubs NA Milieu$ SYSTEM TABLE NA I have two problems. (1) For loading the tables in R, I use > sqlFetch(connection,"Faune$") [1] "37000 -3506 [Mi...

...second avg: 0.041 Yet if i use R's RODBC or RMySQL to connect to my database i can't see these accentuated characters: library(RODBC) con <-odbcConnect("trybunal", uid="root", pwd="mypassword") sqlTable(con) the output (abridged) is like that: TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 14 trybunal Wyk?adnia innych przepis<f3>w TABLE MySQL instead of <F3> i should see "?" and instead of ? a "?". It is just the same if i use RMySQL instead of RODBC: library(RMySQL) con <-dbConn...

I'm tryuing to get the RODBC package to work with a MS Sql database (Wonderware's InSQL). I'm able to connect to the database using the following: version _ platform i386-pc-mingw32 arch x86 os Win32 system x86, Win32 status Under development (unstable)

...ist is: ... 25 Runtime dbo AnalogHistory TABLE ... A abbreviated Column List is as follows: > odbcColumns(channel,"AnalogHistory") odbcColumns(channel,"AnalogHistory") [1] 1 > sqlGetResults(channel) sqlGetResults(channel) TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME DATA_TYPE TYPE_NAME 1 Runtime dbo AnalogHistory DateTime 11 datetime 2 Runtime dbo AnalogHistory TagName 12 varchar 3 Runtime dbo AnalogHistory Value 6 float 4 Runtime dbo AnalogHisto...

...odbcConnect > sqlSave(channel, USArrests, rownames = "state", addPK=TRUE) Error in sqlSave(channel, USArrests, rownames = "state", addPK = TRUE) : [RODBC] ERROR: Could not SQLExecDirect > odbcGetErrMsg(channel) character(0) > sqlTables(channel) TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 opus usarrests TABLE MySQL table --------------------------------------------------------------------- The next thing I did was to check from the MySQL commandline what the status of the database was. ------------------------ MySQL...

...4 15/12/2003 12:15:06 217,1 2758 8,3 35,1 79,6 86,4 15/12/2003 12:15:07 217,1 2768 8,3 35,1 79,6 86,4 My code (i use the R 1.7.1 for windows xp) is the following: library(RODBC) > canal<-odbcConnectExcel("c:/prueba4.xls") > tablas<-sqlTables(canal) > tablas TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 c:\\prueba4 <NA> Hoja1$ SYSTEM TABLE <NA> 2 c:\\prueba4 <NA> Hoja2$ SYSTEM TABLE <NA> 3 c:\\prueba4 <NA> Hoja3$ SYSTEM TABLE <NA> > tbl<-sqlFetch(canal,substr(tablas[1,3],1,nchar(ta...