Dear,
I'm new in here and only 6 month ago I started to learn PHP - still stupid though...
I've have a lot of data to be imported daily to SQL Database table with the coloumn setting same (on both table Excel and SQL).
I would like to make simple php, that could browse the excel file and submit the into SQL.
It is easy to import using Navicat, but not secure if the user or the operator doing import from Navicat.
Please help...
Rgds
Donny
Option 1: http://sourceforge.net/projects/phpexcelreader/
Option 2: Save your excel files in csv format rather than xls format. Mysql can direct load data from a csv file or you also also your PHP to read a csv file and it will be just plain text.
Option 3: Create a ODBC DSN using the Excel file driver. you can connect via odbc and retrieve the contents of the excel file.
If you are try to import into SQL server etc, then they support this import process by default (it uses method 3 
)