question

[rengy]

i want to do a system which can read an excel file and then import the data into the mysql database.

can i use the php script to read the file from the client node and import int the database?
or i have to let the client to upload the file to my server before the file can be read and import into the database ?

please help to clear my doubt.

can someone gives me sites for tutorial on reading excel file and import into database?
i only have found some which read the notepad file.

[Roger_Ramjet]

search for fgetcsv in the manual. Loads of user notes to help you.

[Sxooter]

There's a commercial PHP class out there that I've played with a bit in the past. Seemed ok for what we used it for back then.

http://www.softclub.org/excelexplorer/

But at $129.95 it's a bit pricy for just messing around with.

[csn]

If you're on Window and have Excel installed, then you could probably use COM or ActiveX, or maybe even the commandline.

[Roger_Ramjet]

Another, and my prefered option, save the file as a csv. Excel mashes data too easily to be reliable for data transfer.