Netflix Prize for Dummies [III]
Now we’ve got the data into a MySQL database, so next step is accessing it from our prefered application (sometimes, that means MS Excel, i.e.). So, let’s go:
1) Make sure you system is up to date (specially the Jet Engine).
2) Download and install the last MySQL ODBC Connector.
3) Go to Start_Settings_Control Panel_32bit ODBC and create a new DNS (choose MySQL driver).
Once finished, you’ll be able to access the data from MS Excel. However, you have to take into account you can’t view the data in the spreadsheet since the volume of rows is huge. The good thing is you’ll be able to calculate the statistics from there, or get data from pivot table, etc.
Oops! It seems we have found nothing related.
You can try OpenOffice.org Base as well!
Comment by Francisco Marco-Serrano — August 1, 2007 @ 8:33 am