rickey kyle w omwoerbknrbakerhughescom thanks john ill check kyle rickey original message john machin mailtozmsfhcxflexiconnet sent sunday march 16 2008 440 rickey kyle w cc kpitckaew45pythonorg subject pythonwin32 running sql queries excel sheets rickey kyle w wrote tim thanks response ive got 7 excel files need reading containing total 6100 rows agree code making sick thats exactly absolutely tons data one problem odbc approach reading spreadsheets least ms excel odbc driver examines limited number eg 8 10 rows determine type column first 10 rows floats column x noddys managed get text cell x11 fatal error odbc cant continue snip 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 consider xlrd package httpwwwlexiconnetsjmachinxlrdhtm itll tell type data cellbycell compare expectations hth john _______________________________________________ pythonwin32 mailing list kpitckaew45pythonorg httpmailpythonorgmailmanlistinfopythonwin32 wed 06 aug 2008 063914 0500 pythonwin32 running sql queries excel sheets