ODBC and Excel

Clive Bluston clive at emultek.co.il
Thu Apr 18 11:27:43 EDT 2002


I am new to Python. I am trying to read from an Excel file and cannot even
get connected. The following code gives me:
dbi.internal-error: [Microsoft][ODBC Driver Manager] Invalid string or
buffer length in LOGIN
Has anyone any idea what I may be doing wrong?

import dbi, odbc;

        s = odbc.odbc('ODBC;Driver={Microsoft Excel Driver
(*.xls)};DBQ=d:\\clive\\python\\DEFAULT.XLS;DriverID=790')
 Timeout=5;')






More information about the Python-list mailing list