Re: Python help for Access database

2006-07-31 Thread John Machin
BartlebyScrivener wrote: > John Machin wrote: > > >> or mxODBC > >> [very good but not free]. > > I love mxODBC. It's free for noncommercial use. > I was presuming that the OP was mucking about with Access only because he was so constrained by his job :-) -- http://mail.python.org/mailman/listi

Re: Python help for Access database

2006-07-31 Thread BartlebyScrivener
John Machin wrote: >> or mxODBC >> [very good but not free]. I love mxODBC. It's free for noncommercial use. http://www.egenix.com/files/python/mxODBC.html rd -- http://mail.python.org/mailman/listinfo/python-list

Re: Python help for Access database

2006-07-31 Thread John Machin
shakir wrote: > HI All, > > I need help for inserting recods into the access database using python > script through ODBC. I can insert data without any problem if I hard > coded the run_Date field. But I need run_Date field should be mytime.. > I am getting error Data type mismatch in criteria exp

Python help for Access database

2006-07-31 Thread shakir
HI All, I need help for inserting recods into the access database using python script through ODBC. I can insert data without any problem if I hard coded the run_Date field. But I need run_Date field should be mytime.. I am getting error Data type mismatch in criteria expression. in EXEC I really