build query for active record insert

[eluser]efishant[/eluser]
as grahack mentioned, active records doesn't handle the insertion of multiple rows in one statement (if I'm wrong, please let me know!). How will rebuilding your array help you either way? Why not just build a string with the "INSERT INTO" statement given in the example above.
Here's my proposed solution. With this, you will only need to loop 1 array and you only call the DB once:

Code:

$sql = "INSERT INTO mytable (uniqueId, lotNum, title, description, etc) VALUES ";
for ($i = 0; $i < count($excelData); $i++) {
        $comma = ($i!=(count($excelData)-1))?",":"";
        $sql .= "('NULL', {$excelData[$i][1]}, {$excelData[$i][2]}, {$excelData[$i][3]})$comma";
}
    $result = $this->db->query($sql);