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

[DavidMU]

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

[amitchandak]

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

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

[DavidMU]

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]

SQL Data Table

Excel Lookup table

Is this what you mean?

Regards

David