Skip site navigation (1) Skip section navigation (2)

Re: Is there any known issue with MS-Office >2000 fetching Data?

From: "Relyea, Mike" <Mike(dot)Relyea(at)xerox(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Cc: "Andreas" <maps(dot)on(at)gmx(dot)net>
Subject: Re: Is there any known issue with MS-Office >2000 fetching Data?
Date: 2009-07-31 20:05:23
Message-ID: AF7D9319B29A0242A33C3BF843BD3133088FBD82@USA7061MS03.na.xerox.net (view raw or flat)
Thread:
Lists: pgsql-odbc
> Hi,
> sure it's kind of OT but please bear with my question a wee bit.
> Perhaps you know a better place to ask PG, ODBC + Access questions?

You can try www.utteraccess.com  I've often had helpful hints there.
 
> I work on this Access app. that occasionally has to export to 
> (the one and only globally accepted data transport container) Excel.

I do the same.  The connections, size of the dataset and query
complexity are more than Access can handle.  I just basically use it as
a front end.

> My work pc has PostgreSQL 8.4 + psqlODBC 8.4 as well as 
> Office 2000 installed.
> So my app does the usual chore ... get a connection and a 
> readonly recordset ... open a excel-file ... try to dump with 
> CopyFromRecordset into a range-object of Excel.
> Connection: tried with Client- and ServerCursor
> Recordset: adLockReadOnly,  adOpenForwardOnly  or adOpenStatic

I tried going the straight recordset path but seem to recall running
into issues where Access would barf on some export actions that should
have gone through just fine.  It's been a few years since I struggled
with this though so my memory is a little hazy.

What I do know for sure is that when I'm exporting any data I use a
different approach.  I build pass through queries - which if I remember
correctly can't be exported directly? - and put the results of the pass
through query into a local Access table and finally export the contents
of the table.  I've written functions to create the pass through query
and to transfer the query results to a table.  Then I just use the
DoCmd.TransferSpreadsheet command to export the table.  It definitely
would seem better to be able to do it all straight from a recordset but
that wasn't working as expected

Mike

In response to

pgsql-odbc by date

Next:From: Lothar BehrensDate: 2009-08-01 17:36:35
Subject: Strange bug (value on stack changed)?
Previous:From: AndreasDate: 2009-07-30 04:36:18
Subject: Is there any known issue with MS-Office >2000 fetching Data?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group