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

Re: Trouble Importing Data to Excel "unable to obtain a list of tables"

From: "Carter Patterson" <carter(at)fortedata(dot)com>
To: "'PostgreSQL ODBC List'" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Trouble Importing Data to Excel "unable to obtain a list of tables"
Date: 2003-06-18 14:11:52
Message-ID: 002b01c335a3$918500a0$f90000c0@carter (view raw or flat)
Thread:
Lists: 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(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Jeff Eckermann
Sent: Wednesday, June 18, 2003 9:05 AM
To: Rommel the iCeMAn; PostgreSQL ODBC List
Cc: carter(at)fortedata(dot)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(at)sunbeach(dot)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(at)postgresql(dot)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


In response to

pgsql-odbc by date

Next:From: George E BraddyDate: 2003-06-18 16:21:18
Subject: version considerations
Previous:From: Jeff EckermannDate: 2003-06-18 14:05:04
Subject: Re: Trouble Importing Data to Excel "unable to obtain a list of tables"

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