I try reading a password-protected spreadsheet with RODBC, passing a file or an ODBC source to odbcConnect, e.g. con = odbcConnect(dsn = "mywkbk", uid = "", pwd = "mypwd") but get "Could not decrypt file" pop-up error message. Can anyone help? Thank you. -- View this message in context: http://n4.nabble.com/Reading-a-password-protected-Excel-workbook-tp1568925p1568925.html Sent from the R help mailing list archive at Nabble.com.
Dimitri Shvorob wrote:> > I try reading a password-protected spreadsheet with RODBC, passing a file > or an ODBC source to odbcConnect, e.g. > > con = odbcConnect(dsn = "mywkbk", uid = "", pwd = "mypwd") > > but get "Could not decrypt file" pop-up error message. > >Not really: http://support.microsoft.com/default.aspx/kb/211378/EN-US/ Dieter -- View this message in context: http://n4.nabble.com/Reading-a-password-protected-Excel-workbook-tp1568925p1569030.html Sent from the R help mailing list archive at Nabble.com.
Use RDCOMClient or rcom to open it and then use RODBC to read it. On Thu, Feb 25, 2010 at 7:26 AM, Dimitri Shvorob <dimitri.shvorob at gmail.com> wrote:> > I try reading a password-protected spreadsheet with RODBC, passing a file or > an ODBC source to odbcConnect, e.g. > > con = odbcConnect(dsn = "mywkbk", uid = "", pwd = "mypwd") > > but get "Could not decrypt file" pop-up error message. > > Can anyone help? > > Thank you. > > -- > View this message in context: http://n4.nabble.com/Reading-a-password-protected-Excel-workbook-tp1568925p1568925.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >