#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2014
    Posts
    1
    Rep Power
    0

    ODBC and Excel (PowerPivot) issues


    Hi all,

    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.

    System:
    Win 8.1
    Excel 2013 (tried both the 32 and 64-bit)
    psqlodbc driver (different versions both 32 and 64-bit)

    Any ideas?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    158
    Rep Power
    10
    Hvae you checked postgresql's log to see if it mentions says anything about this procedure?

IMN logo majestic logo threadwatch logo seochat tools logo