First save excel to csv, then code below will do magic
//$file=your file path
$sqlcnt="SELECT COUNT(COLUMN_NAME) as length FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = '".$tblname."'";
$rescnt=mssql_query($sqlcnt);
$row=mssql_fetch_array($rescnt);
echo $n=$row['length']-1;
if (($handle = fopen("$file", "r")) !== FALSE) {
$i=0;
//$j=0;
$dataarr=array();
$finalarr=array();
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$num = count($data);
for ($c=0; $c
if($data[$c]!="")
$dataarr[$i][$c]= "'".$data[$c]."'";
}
$i++;
}
foreach($dataarr as $key=>$val){
if(count($val)==$n){
$finalarr[]=$val;
}
}
foreach($finalarr as $k=>$v){
if($k==0)
continue;
$subsql=implode(",",$v).",'".date('U')."'";
$sql="insert into $tblname values ($subsql)";
mssql_query($sql);
}
fclose($handle);
}
?>