macro to import data from mysql

A

asiva

Hi,

I am developing a web interface for a couple of excel files. I have
done this using mysql and php by dumping the excel data as a csv file.
Now I have the interface ready and we can add new rows/records to the
database.

My problem is, I need to create a button which when clicked will erase
all the previous data in the excel work"sheet" and import the new data
from mysql to this worksheet. The workbook I am working on contains
some other sheets which my employer uses for some analysis.

I am working in Excel for Mac, so I cannot use ASP/Access. Any help is
greatly appreciated. Thanks.

Siva
 
Top