Re: Excel sheet operations with PHP

There is some very good software made by a brazillian guy that doies it very automatically - it converts CSV files, excel and access into mySQL. Not sure of the name. Anyone? --- Maxim Maletsky maxim@php.net www.PHPBeginner.com // PHP for Beginners www.maxim.cx // my Home // my Wish List: ( Get me something! ) http://www.amazon.com/exec/obidos/registry/2IXE7SMI5EDI3 Justin French <justin@indent.com.au> wrote... : > I save excel sheets as CSV (Windows, not Mac), then use functions like > fget_csv() to read the CSV file one line at a time, inserting into MySQL > with standard insert queries. > > Have a go, and let me know if you need more help. I'm pretty sure there are > decent samples of everything except the mysql stuff in the manual... I'll > make the assumption you know how to insert :) > > > Justin > > > > on 23/10/02 8:19 PM, Balaji Ankem (balaji.ankem@wipro.com) wrote: > > > Hi Friend, > > How to read from Excel file and to insert in to the database? > > Do we have any option to import excel sheet to Mysql database through > > php? > > Or any other mechanism? > > > > Any inputs will be greatly appreciable. > > > > Thanks and Regards > > Balaji > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >