เป็นโค้ดการ import เมื่อรันแล้วจะแสดงข้อความว่า  import เรียบร้อยแล้ว  แต่ในฐานข้อมูลไม่มีข้อมูลที่ import ค่ะ
เป็นเพราะอะไรหรอคะ  รบกวนผู้รู้ทุกท่านดูโค้ดให้หน่อยนะคะ  ขอบคุณล่วงหน้าค่ะ


<?
 //*** Get Document Path ***//
 $strPath = realpath(basename(getenv($_SERVER["SCRIPT_NAME"])));
 $OpenFile = "student.xls";
 //*** Create Exce.Application ***//
 $xlApp = new COM("Excel.Application");
 $xlBook = $xlApp->Workbooks->Open($strPath."/".$OpenFile);
 //$xlBook = $xlApp->Workbooks->Open(realpath($OpenFile));

 $xlSheet1 = $xlBook->Worksheets(1); 

 //*** Insert to MySQL Database ***//
 $objConnect = mysql_connect("localhost","root","abc123") or die("Error Connect to Database");
 mysql_query("SET NAMES TIS620");
 $objDB = mysql_select_db("student");

 for($i=2;$i<=3;$i++){
  If(trim($xlSheet1->Cells->Item($i,1)) != "")
  {
   $strSQL = "";
   $strSQL .= "INSERT INTO cpu_std ";
   $strSQL .= "(STD_ID, USER, PASSWORD, CITIZEN_ID, PROGRAM_ID,YEAR,PREFIX_NAME,STD_FNAME,STD_LNAME,GENDER,BIRTHDAY,PROVINCE_ID,LEV,CURR,FAC,ISCED,PROGRAM,GPA,HOMEADD,MOO,HOME,SOI,STREET,TAMBON,AMPHUR,PROVINCE,ZIPCODE,TEL,TELEPHONE,FAX,RACE,RELIGION,EMAIL,STATUS_STD) ";
   $strSQL .= "VALUES ";
   $strSQL .= "('".$xlSheet1->Cells->Item($i,1)."','".$xlSheet1->Cells->Item($i,2)."' ";
   $strSQL .= ",'".$xlSheet1->Cells->Item($i,3)."','".$xlSheet1->Cells->Item($i,4)."' ";
   $strSQL .= ",'".$xlSheet1->Cells->Item($i,5)."','".$xlSheet1->Cells->Item($i,6)."') ";
   $strSQL .= "('".$xlSheet1->Cells->Item($i,7)."','".$xlSheet1->Cells->Item($i,8)."' ";
   $strSQL .= ",'".$xlSheet1->Cells->Item($i,9)."','".$xlSheet1->Cells->Item($i,10)."' ";
   $strSQL .= ",'".$xlSheet1->Cells->Item($i,11)."','".$xlSheet1->Cells->Item($i,12)."') ";
   $strSQL .= "('".$xlSheet1->Cells->Item($i,13)."','".$xlSheet1->Cells->Item($i,14)."' ";
   $strSQL .= ",'".$xlSheet1->Cells->Item($i,15)."','".$xlSheet1->Cells->Item($i,16)."' ";
   $strSQL .= ",'".$xlSheet1->Cells->Item($i,17)."','".$xlSheet1->Cells->Item($i,18)."') ";
   $strSQL .= "('".$xlSheet1->Cells->Item($i,19)."','".$xlSheet1->Cells->Item($i,20)."' ";
   $strSQL .= ",'".$xlSheet1->Cells->Item($i,21)."','".$xlSheet1->Cells->Item($i,22)."' ";
   $strSQL .= ",'".$xlSheet1->Cells->Item($i,23)."','".$xlSheet1->Cells->Item($i,24)."') ";
   $strSQL .= "('".$xlSheet1->Cells->Item($i,25)."','".$xlSheet1->Cells->Item($i,26)."' ";
   $strSQL .= ",'".$xlSheet1->Cells->Item($i,27)."','".$xlSheet1->Cells->Item($i,28)."' ";
   $strSQL .= ",'".$xlSheet1->Cells->Item($i,29)."','".$xlSheet1->Cells->Item($i,30)."') ";
   $strSQL .= "('".$xlSheet1->Cells->Item($i,31)."','".$xlSheet1->Cells->Item($i,32)."' ";
   $strSQL .= ",'".$xlSheet1->Cells->Item($i,33)."','".$xlSheet1->Cells->Item($i,34)."' ";
   mysql_query($strSQL);
   
  }
 }
 if($strSQL){ echo"Import เรียบร้อยแล้ว";}
 else{echo"ไม่สามารถ Import ได้";}
 //*** Close MySQL ***//
 @mysql_close($objConnect);

 //*** Close & Quit ***//
 $xlApp->Application->Quit();
 $xlApp = null;
 $xlBook = null;
 $xlSheet1 = null;
 
?>