On Jan 3, 2007, at 2:10 AM, rajibsukanta wrote:

> 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 ...

Nice work.  You should be able to safely remove those +'s, but do  
what works best for your situation.
Good luck with the rest of the project.
-Mat