January 15th, 2014, 09:35 AM
ODBC and Excel (PowerPivot) issues
I am trying to use Excel and through ODBC to pull data in PowerPivot. The problem is that the connection is successful (both according to excel but also when trying to pull data using a custom query) but when I try to pull the entire list of tables (in the Table Import Wizard) through the "Select from a list of tables and views to choose the data to import" I get the following error msg:
No tables were found in the data source. Check the connection information and login credentials.
Excel 2013 (tried both the 32 and 64-bit)
psqlodbc driver (different versions both 32 and 64-bit)
January 16th, 2014, 01:53 AM
Hvae you checked postgresql's log to see if it mentions says anything about this procedure?