Are there no tabs/newlines in the data? If not, then copy the data into notepad and save the file.
Read the file into a string
then do this
//suppose these were your columns
$col[1]="FirstName";
$col[2]="LastName";
$col[3]="Email";
$array=explode("\n",$string);
foreach($array as $v){
$record=explode("\t",$v);
$sql="INSERT INTO table SET ";
foreach($col as $n=>$v){
$sql.=$col[$n+1]."='". addslashes($record[$v])."',";
}
$sql=substr($sql,0,strlen($sql)-1);
//now execute or print the query here
}
Sam
