Hmm, I don't have much experiance with Excel, but I have found the Query
wizard to not work too well. I found that if I went to: Data->Import
External Data->New Database Query then make sure the "Use the Query
Wizard" box is unchecked, select my DSN, then clock the "SQL" button and
then type in a SQL statement, it would input the data correctly into
Excel. Note, you may have to put quotation marks around the table/column
names.
Kelsey Forsythe wrote:
> I am trying to link Microsoft Excel on a Dell running XP to a PostgreSQL
> database on a Linux box.
> I've setup the DBN (ODBC) in AdminSettings--> Data Sources
>
> And I can go into Excel at go through all the Data Source setup
> and test the connection (it is fine) BUT I receive 'Unable to obtain
> list of tables from data source'
> What other information besides the username and password do I need?
>
> Do I need to configure the server in some way to allow upload of this
> information?
> Maybe the server firewall is setup to not allow this?
> Maybe I need to setup a UDL?
>
> Although I can get to that same port using a Tomcat application.
>
> Any help is appreciated.
>
> Thanks,
>
> Kelsey
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>