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 imp...
Need Help
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