Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I import data from a mysql database into excel | Excel Discussion (Misc queries) | |||
Formatting datetime problems importing data from mysql db | Excel Discussion (Misc queries) | |||
Using Excel for MySQL database import | Excel Discussion (Misc queries) | |||
Import MySQL data to Excel | Excel Discussion (Misc queries) | |||
importing data from MySQL | Excel Programming |