
December 10th, 2003, 11:43 PM
|
|
Registered User
|
|
Join Date: Nov 2003
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
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
|