I am creating a module for Magento. For this I need already inserted data in table. For this I need to write sql/module_setup/mysql4-install-0.1.0.php installer script to insert data from excel or csv to table.


my installer script is like this to create table

    $installer = $this;
    
    $installer->startSetup();
    
    
    $installer->run("
    
    CREATE TABLE `{$this->getTable('module_setup_data')}` (
      `id` int(10) unsigned NOT NULL auto_increment,
      `code` varchar(255),
      `code_type` varchar(255),
      PRIMARY KEY  (`id`),
    
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
        ");
    
    $installer->endSetup();




Please guide me how to write sql/module_setup/mysql4-install-0.1.0.php installer script to insert query from excel or csv.