Postgres Pro
Downloads
Home   >   mailing lists

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

From Carter Patterson
Subject Trouble Importing Data to Excel "unable to obtain a list of tables"
Date
Msg-id 002601c334cb$5f758a90$f90000c0@carter
Whole thread Raw
Responses Re: Trouble Importing Data to Excel "unable to obtain a list of tables"
List pgsql-odbc
Tree view

I am trying to connect Excel and Postgres. 

 

I have Postgres 7.3.2 installed on RH 8.0 box.

I have loaded pgsqlodbc 7.3.1 installed on my Windows XP Professional.

MS Excel 2002

 

I went to Control Panel, Admin Tools, DataSources and added a DSN for Postgres.  I checked the 7.X, 6.4 box.

I also told it to show system tables.

 

 

In Excel, I choose Data, Import External Data, Import Data, Connect to New Data Source---

 

This takes me to the Excel Wizard where I choose ODBC – DSN, then I select Postgresql30.  It then tells me unable to obtain a list of tables.

 

Any help or direction to documentation would be appreciated.  thanks

 

 

 

pgsql-odbc by date:

Previous
From: "Rommel the iCeMAn"
Date:
Subject: Re: [Tiny-cobol-users] New compiler options RFC
Next
From: Jeff Eckermann
Date:
Subject: Re: Trouble Importing Data to Excel "unable to obtain a list of tables"