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
