Re: Trouble Importing Data to Excel "unable to obtain a list of tables" - Mailing list pgsql-odbc

From Carter Patterson
Subject Re: Trouble Importing Data to Excel "unable to obtain a list of tables"
Date
Msg-id 002b01c335a3$918500a0$f90000c0@carter
Whole thread Raw
In response to Re: Trouble Importing Data to Excel "unable to obtain a list of tables"  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-odbc
No, I only use lower case names.

I was able to import data into excel via another method.  Instead of
using the Excel selection "Import Data", I selected New Database Query,
which essentially runs MS Query.  This worked just fine.

This would lead me to believe that there is a good possibility that the
Import Data feature of Excel has its own bugs.

Thanks for your help everyone.

-----Original Message-----
From: pgsql-odbc-owner@postgresql.org
[mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Jeff Eckermann
Sent: Wednesday, June 18, 2003 9:05 AM
To: Rommel the iCeMAn; PostgreSQL ODBC List
Cc: carter@fortedata.com
Subject: Re: [ODBC] Trouble Importing Data to Excel "unable to obtain a
list of tables"

Carter,
Just curious: was this the problem?
Jeff

--- Rommel the iCeMAn <iceman@sunbeach.net> wrote:
> I also had a strikingly similar problem while trying
> to connect from Crystal
> Reports. It only worked when I changed all the
> PostgreSQL table names to
> lowercase. I read somewhere that uppercase names can
> be used if enclosed in
> quotes but that didn't work for me.
>
> just a suggestion :-)
> Rommel the iCeMAn
> Computer Programmer
> Barbados, Caribbean.
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org


pgsql-odbc by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: Trouble Importing Data to Excel "unable to obtain a list of tables"
Next
From: Chris Gamache
Date:
Subject: Getting intermittent 800a01fb errors