Welcome to WebmasterWorld Guest from 23.22.206.103

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
posts:176
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?

cheers

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
posts:4392
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.

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members