Load data

[Tezread]

Not sure if this is the right thread but here goes..

Im trying to load data into a table 'courseoutcomes with a design as follows:

Courseoutcomeid (auto_increment, primary key)
Coursename char (50)
Courseoutcome blob

I have created the txt file by exporting a query in MS Access. In the text file is just the two fields coursename and coureoutcome. I delimited by choosing a comma as a seperator- the preview in Access looks ok.
My problem is when I load data the table is populated but with null values. What have I done wrong?

[lucasrd]

take a look at [man]file[/man] it reads a file and puts each line into an array...

$lines = file("/path/to/file");
while(list($key,$val) = each($lines)){
  $values = explode(",",$val);
   $sql = "insert into courseoutcomes set coursename='".$values[0]."', courseoutcome=''".$values[1]."";
mysql_query($sql);
}