Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Excel-2-MySQL & MySQL-2-Excel

how can I convert from one to the other?

3:41 pm on Oct 17, 2005 (gmt 0)

Junior Member

10+ Year Member Top Contributors Of The Month

joined:Aug 5, 2004
votes: 0

Does anyone know of any software that will
let me export some fields from different tables
(pre-selected by me) to excel so the user can then
edit the data and import it back to mysql.

I don't want to to give the user full access to
all the tables, just some of the fields on a few of
the tables.

does anyone know if this is possible and what
software I should check out?


3:57 pm on Oct 17, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Sept 1, 2001
votes: 0

you can write something to do that. You can create the excel file dynamically and populate it from the database based on a user input query.

You can also open an Excel file using the File System Object (in ASP) and read from it to write into a database.

We just started discussing this in the Microsoft forum above. Might help you as well.