best thing I do is import it manually, export a tab delimited file from excel
that will produce a simple txt file readable in PHP
I then read the file in PHP
run a loop for each line in the file which will correspond to each entry in the excel file and explode the line by "TAB" that way I insert only the information I want.
At this point you can either: run a sql INSERT statement for each line, which is the easiest but slowest way if you have alot of records
or put that withitng another loop to group value sets for entry
That should pretty much take care of it
