PDA

View Full Version : [ubuntu] Newbie looking for MySQL help



sqlyee
March 30th, 2010, 12:19 AM
I have a 9.10 Ubuntu LAMP server running. I have a database installed in MySQL and would like to provide read only access to Windows clients on the local area network via Excel (Office 2007). I know I need an ODBC manager and an ODBC driver. Where do I get these and how do I configure them?

I am able to do queries via http by using phpMyAdmin. I need to provide this through Excel.

Anyone have any ideas?