[excel 2003 sp2, postgresql odbc driver 8_01_0200] When I use MS-Query to get data from my postgresql server via odbc, the query succeeds and displays in the msquery window. But when I say "return data to excel" it re-runs the query. Is there some way to make it just pass what it has instead of re-executing a sometimes lengthy query? [if this is the wrong forum for this, please forgive me and suggest where I should post] -- George
George If you run the 'query' through Data>Get external data... It should only run it once without showing the msQuery interface, unless you elect to do so in the last step of the wizard. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS wrote in message news:1144079297.399593.305830@g10g2000cwb.googlegroups.com... > [excel 2003 sp2, postgresql odbc driver 8_01_0200] > When I use MS-Query to get data from my postgresql server via odbc, > the query succeeds and displays in the msquery window. But when I say > "return data to excel" it re-runs the query. Is there some way to make > it > just pass what it has instead of re-executing a sometimes lengthy > query? > > [if this is the wrong forum for this, please forgive me and suggest > where > I should post] > > -- George >
