You have to format the columns of the excelsheets to read and arrange in order exactly as your mysql table fields reads and ordered eg. if a table student has name, regno then the corresponding excel sheet column head should read name, regno. so each sheet in an excel work book corresponds to one table in mysql (workbook can have several sheets). You can then use a client program like Navicat to load your data in mysql db (excel to mysql is possible) or convert/save your sheet as text file (cvs) then load. if there is a date column on excel sheet u need to keep an eye on it, usualy the date is imported in a strange way say 1890-12-30 goodluck Lungo --- Knowles Burrell <kburrell3@gmail.com> wrote: > save the file as cvs. Shouldnt be a problem > importing then. > > > On Sat, 16 Oct 2004 12:35:39 -0000, ejaincom > <ejaincom@yahoo.com> wrote: > > > > > > Dear Friends, > > As a part of a project to me i want to convert > excell workbook to a > > format where i can save the results into mysql > database. > > > > Please if anyone here have an idea to do so let > me know. > > Thanks in advance for your help and time. > > -- > > Regards, > > Abhishek jain > > > > > > > > > > > > > > > > > > PHP Data object relational mapping generator - > > http://www.meta-language.net/ > > > > > > > > Yahoo! Groups Sponsor > > > > ADVERTISEMENT > > > > > > ________________________________ > > Yahoo! Groups Links > > > > To visit your group on the web, go to: > > http://groups.yahoo.com/group/php-objects/ > > > > To unsubscribe from this group, send an email to: > > php-objects-unsubscribe@yahoogroups.com > > > > Your use of Yahoo! Groups is subject to the Yahoo! > Terms of Service. > __________________________________ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> PHP Data object relational mapping generator - http://www.meta-language.net/ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-objects/ <*> To unsubscribe from this group, send an email to: php-objects-unsubscribe@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
