accessing mysql data from excel

Hi,

I need to access data (originally from excel) stored in a mysql database from excel. I am using Excel for Mac, so I cannot use ASP/Access.

What I need is to write a macro that "refreshes" a worksheet. I intend to delete all the data in the worksheet ( this I know ) and then retrieve the data from mysql into this worksheet. How can I do this? Any suggestions, links are greatly appreciated.

I had originally created the web interface from excel files. Now we can add new records to the database, but i need to access this data from excel in excel format as my employer needs to do some analysis using this "refreshed" worksheet and other worksheets in the same workbook.

Thanks.

Siva

I have no solution to work out it!But i recommend u to find some knowledge about how to get data by access mysql in vbs!..