Since everyone wanted to see (i got an overwhelming response) i am adding the code for the benefit of the comunity: The idea is that i have a table for security data a table for portfoilios and portfolio names. Since my time is limited, I decided to post the code with no comments and I will write a different time explaining what I have sent ----- Original Message ----- From: "Daniel Flam" <daniel@xxxxxxxxxxxxxx> To: <tech-spec@xxxxxxxxxxxxx> Sent: Tuesday, December 14, 2004 3:05 PM Subject: [tech-spec] Re: MySQL & R > I just got in from israel... sorry for the delay, Ill post later my > functions for accesing the MySQL from windows > I use it great and I have a perl program to populate the MySQL database from > yahoo if anyone is interested > > > ----- Original Message ----- > From: "BBands" <BBands@xxxxxxxxxxxxxxxxxx> > To: <tech-spec@xxxxxxxxxxxxx> > Sent: Tuesday, December 07, 2004 12:28 PM > Subject: [tech-spec] Re: MySQL & R > > > > Can't get DBI and RMySQL working on Windows. DBI and RODBC work fine, but > I > > have always been leery of ODBC and wanted to go direct to MySQL skipping > the > > intervening layer. Is ODBC really a viable way to go??? Any comments on > > this? > > > > Another alternative is to access MySQL via Python which also works well. > > Indeed running R via Rpy from Python seems like a really cool way to go. > > > > --jab > > > >