search for: pagetimeout

...k. Following an example in Phil Spector's book (p. 34), after 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$ S...

...s and I do the code this way: channel <- odbcConnectAccess("C:/Users/Documents/XYZ") channel and it gave me this : RODBC Connection 3 Details: case=nochange DBQ=C:\USers\JieYi\Documents\NYP\IPP\GCR Driver={Microsoft Access Driver (*.mdb)} DriverId=25 FIL=MS Access MaxBufferSize=2048 PageTimeout=5 UID=admin I have a total of 5 tables in the .mdb database. any one can help me with how to get the tables in ? -- View this message in context: http://r.789695.n4.nabble.com/How-to-connect-mdb-file-tp4636083.html Sent from the R help mailing list archive at Nabble.com.

...("RODBC") Z>cnct<-odbcConnectExcel("Forbes2000.xls") Z>cnct RODB Connection 1 Details: case=nochange DBQ=C:\Program Files\R\R-2.5.0\Forbes2000.xls DefaultDir=C:\Program Files\R\R-2.5.0 Driver={Microsoft Excel Driver (*.xls)} DriverId=790 MaxBufferSize=2048 PageTimeout=5 Z>sqlQuery(cnct, "select * from \"Forbes2000\\$\"") However, I got error like this: [1] "[RODBC] ERROR: Could not SQLExecDirect" [2] "42S02 -1305 [Microsoft][ODBC Excel Driver] Microsoft Jet Êý¾Ý¿âÒýÇæ ÕÒ²»µ½¶ÔÏó'Forbes2000\\$'¡£ÇëÈ·¶¨¶ÔÏóÊÇ·ñ´æÔÚ£...

...RODBC) odbcConnectExcel(xlsfile) Here I got following report: RODBC Connection 4 Details: case=nochange DBQ=C:\PROGRA~1\R\R-211~1.1\library\gdata\xls\iris.xls DefaultDir=C:\PROGRA~1\R\R-211~1.1\library\gdata\xls Driver={Microsoft Excel Driver (*.xls)} DriverId=790 MaxBufferSize=2048 PageTimeout=5 My question is *2) How I retrieve data here?* * * Thanks for your time. [[alternative HTML version deleted]]

...035 [Microsoft][ODBC Excel Driver] Operation must use an updateable query." myChan = odbcConnectExcel("c:\\foo.xls") myChan RODB Connection 13 Details: case=nochange DBQ=c:\foo.xls DefaultDir=c:\ Driver={Microsoft Excel Driver (*.xls)} DriverId=790 MaxBufferSize=2048 PageTimeout=5 sqlTables(myChan) TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 c:\\foo <NA> 'my customers orders$' TABLE <NA> 2 c:\\foo <NA> 'my customers$' TABLE <NA> 3 c:\\foo <NA> ...