View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
asiva asiva is offline
external usenet poster
 
Posts: 1
Default macro to import data from mysql

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


---
Message posted from http://www.ExcelForum.com/