[Angelicwolf]

Hi all. I'm new to this and i need help for importing excel data into MySQL DB and print out in html. im supposed to do this for my project and i have juz did some self learning and practice for 4weeks only. i have read a previous thread http://www.programmingtalk.com/showt...threadid=15964 and tried with the code there but it was unsuccessful.

i tried converting the file to .csv and i could print something out but my lecture said that im supposed to import the file in excel format and not any other format. and even using the .csv all my data got into the same column. the data im supposed to import supposed to have 7 columns like this:
Date | Time | Module | Group | Stud | Venue | Module Coordinator |

fyi im currently assigned to a Linux Debian work station. thanks in advance to u guys for the help

[jfulton]

Originally Posted by Angelicwolf

my lecture said that im supposed to import the file in excel format and not any other format. and even using the .csv all my data got into the same column.

What kind of assignment is that??? That's never going to happen in ther real world! If you can use csv, export the xls file to csv and then read it into mysql using LOAD DATA INFILE.

Otherwise, f you have to pick apart the excel file, you may want to do some research on that...I've never touched it before. And tell your lecturer to come up with some useful assignments for you (unless this is a MS course).

[Angelicwolf]

Thank you very much for your advice. I shall continue on what i have now.