Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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/

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I import data from a mysql database into excel Tina Excel Discussion (Misc queries) 3 May 18th 06 04:21 AM
Formatting datetime problems importing data from mysql db PEA Excel Discussion (Misc queries) 2 February 23rd 06 11:04 PM
Using Excel for MySQL database import inspireme Excel Discussion (Misc queries) 1 January 6th 06 10:59 PM
Import MySQL data to Excel mbeyer Excel Discussion (Misc queries) 0 November 30th 05 07:10 PM
importing data from MySQL Amedee Van Gasse[_2_] Excel Programming 4 October 1st 03 10:25 PM


All times are GMT +1. The time now is 11:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"