tim golden cggctimgoldenmeuk rickey kyle w wrote ive got several excel sheets would like run sql queries ive worked couple ways im sure best way would ive also got problem cant connect excel file someone currently editing given following code samples one better guess im asking odbc ado connection better snip code frank make say uuughh think translates american eeewww try access excel via sql years ago gave disgust seemed halfhearted addon prove power odbc early days connecting system wasnt really designed support maybe improved couple things worth bearing mind odbc module pywin32 think effectively unsupported several modern maintained alternatives option par excellence mxodbc module commercially licensed may may problem two pyodbc ceodbc ive heard good things sqlalchemy guys use pyodbc preferred connection sql server secondly adodbapi module wraps messy ado plumbing python dbapicompliant module unmaintained long recently picked vernon cole due included next pywin32 release think obviously helpful point reason cant pull data straight python structures take even push sqlite memory database perhaps youve got absolutely tons data extracting would pain consider using one com packages win32comclient comtypes something like pyexcelerator pull tjg _______________________________________________ pythonwin32 mailing list kpitckaew45pythonorg httpmailpythonorgmailmanlistinfopythonwin32 wed 06 aug 2008 080835 0000 pythonwin32 running sql queries excel sheets