Forum Discussion

DavidMU's avatar
DavidMU
New Member
6 years ago

How to get an Excel Lookup table to work with an SQL Data table

Hi All,

 

I have an Excel Lookup table linked to an SQL data import table linked to a Calendar table. The SQL data table and Calendar table work okay together  but the excel Lookup and SQL data import table do not seem to.

I have exported the data from the SQL query into Excel and this Excel file works with the Excel Lookup table but I need the refreshable SQL table to work with the Excel Lookup table.

The data is the same, is there formating that needs to be done?

 

Regards

David

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    DavidMU , what you mean by excel lookup. Can share the schema Diagram.

    Can you share sample data and sample output in table format?

    • DavidMU's avatar
      DavidMU
      New Member
      6 years ago

      Thanks for getting back to me amitchandak, the S&D table is a Lookup table, the MUe 2018 is an SQL data table and the third on the right is a Calendar table 

      • DavidMU's avatar
        DavidMU
        New Member
        6 years ago

        SQL Data Table

         

        Excel Lookup table

         

         

        Is this what you mean?

         

        Regards

         

        David