search for: table_cat

...st.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 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...

...ter creating 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...

...base using 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"...

...e" "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...

...llowing problem 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:...

...ary(RODBC) $ $ # 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,...

...  I am trying 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...

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 DEFINIT...

...a certain 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...

...without unique 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:\\ARTIFICALDE...

...xercise, but 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, "...

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_databas...

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] "370...

...ueries per 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...

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)

...ed table list 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...

...rameter in 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. -------------------...

...1 79,6 86,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...

...sequence of actions that illustrate the issue. > library(RODBC) ## connect to Excel file using dialog box > z<-odbcConnectExcel() ## List the tables: "Success Rates" is the only worksheet there, of course > sqlTables(z) TABLE_CAT TABLE_SCHEM 1 C:\\Documents and Settings\\bgunter\\My Documents\\LRPdatacln <NA> 2 C:\\Documents and Settings\\bgunter\\My Documents\\LRPdatacln <NA> 3 C:\\Documents and Settings\\bgunter\\My Documents\\LRPdatacln <NA> TABLE_NAME TABLE_TYPE...

...have 9 rows of data. There seem to be either 8 columns or 10 columns of data. >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,...