Thanks  for the lead it is resolved
  Try something like:
>
> >>> csv_name = 'c:\\mooney.com\\NSEDATA\\'+f
> >>> 	       res = db.query('load data infile \''+csv_name+'\' into table
> >>> nsehistory fields terminated by \',\'
> >>>   lines terminated by \'\n\' ignore 1 lines')
>
i had to do it  this way
csv_name = 'c:\\'+'\\mooney.com\\'+'\\NSEDATA\\'+'\\' +f
and now it is fine ...




cheers