| Welcome to WebmasterWorld Guest from 18.104.22.168 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Become a Pro Member|
|Excel-2-MySQL & MySQL-2-Excel|
how can I convert from one to the other?
| 3:41 pm on Oct 17, 2005 (gmt 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
does anyone know if this is possible and what
software I should check out?
| 3:57 pm on Oct 17, 2005 (gmt 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.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved