rickey kyle w omwoerbknrbakerhughescom tim thanks samples quite handy ill play see come issue see reading excel files every time files stored network vpn access horribly slow might take slow connection ive got ideas turning head im gon na try couple different things thanks help kyle rickey original message ucoesrtuo10fuogcucoesrtuohufuogcucoesrtuohpythonorg mailtoucoesrtuo10fuogcucoesrtuohufuogcucoesrtuohpythonorg behalf tim golden sent friday march 14 2008 1124 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 perfect world would get data sql server write front end everyone needs accessmodify data thats ways road ive still got convince people company excel good way store database info dont problem extracting data throwing sqlite problem would need extract data every time wanted run query ive also got code laying around com excel read data pretty either think good temporary solution might excel macro runs whenever file open whenever someone saves changes excel file would dump data sql server whenever get around making frontend data already sql thanks help kyle rickey well obviously know youre compare things bit attach two small complete pieces code first generates excel workbook 6000 lines data containing hundred numbers randomly shuffled second im trying get pulls first 20 values row inserts noddy table sqlite database respectablebutnotblazing machine first takes thirty seconds second two seconds data ridiculously simple suppose wanted illustrate easy could pull data excel workbook rugged realworld experience chime crufty bits youd cope datetime fields concurrent access like perhaps peoples data simple mine import os sys import random import win32comclient filename ospathabspath dataxls ospathexists filename osremove filename xl win32comclientgencacheensuredispatch excelapplication try wb xlworkbooksadd ws wbactivesheet line range 100 row range 1 6000 print row row randomshuffle line wsrange wscells row 1 wscells row len linevalue line wbsaveas filename finally xlquit import os sys import win32comclient import sqlite3 filename ospathabspath dataxls db_filename ospathabspath datadb ospathexists db_filename osremove db_filename xl win32comclientgencacheensuredispatch excelapplication db sqlite3connect db_filename dbexecute create table data integer b integer c integer integer e integer f integer g integer h integer integer j integer k integer l integer integer n integer integer p integer q integer r integer integer integer try wb xlworkbooksopen filename ws wbactivesheet data wsrange wscells 1 1 wscells 6000 20value dbexecutemany insert data b c e f g h j k l n p q r values data finally xlquit row dbexecute select data limit 100 print row dbclose tjg _______________________________________________ pythonwin32 mailing list kpitckaew45pythonorg httpmailpythonorgmailmanlistinfopythonwin32 _______________________________________________ pythonwin32 mailing list kpitckaew45pythonorg httpmailpythonorgmailmanlistinfopythonwin32 wed 06 aug 2008 031524 0500 pythonwin32 running sql queries excel sheets