[GENERAL] pgodbc + Excel + msquery + background refresh

2007-10-10 Thread Ow Mun Heng
Just wonder if anyone here uses Excel to connect to PG via ODBC. I'm using it extensively as my platform to get data from PG/MSSQL directly into excel. (Excel uses the msqry32.exe file which is like a stripped down sql query tool and returns data directly into excel) When using mssql, connecting

Re: [GENERAL] pgodbc + Excel + msquery + background refresh

2007-10-10 Thread Scott Marlowe
On 10/10/07, Ow Mun Heng [EMAIL PROTECTED] wrote: Just wonder if anyone here uses Excel to connect to PG via ODBC. I'm using it extensively as my platform to get data from PG/MSSQL directly into excel. (Excel uses the msqry32.exe file which is like a stripped down sql query tool and returns

Re: [GENERAL] pgodbc + Excel + msquery + background refresh

2007-10-10 Thread Ow Mun Heng
On Wed, 2007-10-10 at 10:22 -0500, Scott Marlowe wrote: On 10/10/07, Ow Mun Heng [EMAIL PROTECTED] wrote: Just wonder if anyone here uses Excel to connect to PG via ODBC. I'm using it extensively as my platform to get data from PG/MSSQL directly into excel. (Excel uses the msqry32.exe

Re: [GENERAL] pgodbc + Excel + msquery + background refresh

2007-10-10 Thread Ow Mun Heng
] pgodbc + Excel + msquery + background refresh On 10/10/07, Ow Mun Heng [EMAIL PROTECTED] wrote: Just wonder if anyone here uses Excel to connect to PG via ODBC. I'm using it extensively as my platform to get data from PG/MSSQL directly into excel. (Excel uses the msqry32.exe file which