search for: defaultdir

...a to import an excel spreadsheet. The spreadsheet has three worksheets the last of which is blank. 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...

Hi, everyone, I try to run as follows: Z>library("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] "42S...

...lid 'file' argument Question *1) What is the way to get it working?* 2nd approach I done was with RODBC package: library(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]]

...inSysPath),,$(Shared) File3=1,,comdlg32.oc_,comdlg32.ocx,$(WinSysPath),$(DLLSelfRegister),$(Shared ) File4=1,,CmDlgFR.dl_,CmDlgFR.dll,$(WinSysPath),,$(Shared) File5=1,,PAC.ex_,PAC.exe,$(AppPath) File6=1,,PAC.DE_,PAC.DEP,$(AppPath) [Setup] Title=EPAS Version 2.1.0 DefProgramGroup=EPAS Version 2.1.0 DefaultDir=$(ProgramFiles)\EPAS Version 2.1.0 Setup=setup1.exe AppExe=PAC.exe AppToUninstall=PAC.exe AppPath= ==================================== All the dll are uncompressed into the windows\system directory except OLEAut32.dll which doesn't get unpacked at all. Is OLEAut32.dll already emulated by win...

...#39;,5678 ) " ) [1] "[RODBC] ERROR: Could not SQLExecDirect" "S1000 -3035 [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>...

.../span><span class="cx"> * "FileDialog#show_modal":#FileDialog_showmodal </span><span class="cx"> </span><span class="lines">@@ -77,8 +94,10 @@ </span><span class="cx"> %(arg-type)String% defaultDir = "", </span><span class="cx"> %(arg-type)String% defaultFile = "", </span><span class="cx"> %(arg-type)String% wildcard = ".*", </span><del>- %(arg-type)Intege...