I am trying to read one table from a sql server and one excel that has been loaded as a sql serve table. The non excel col I want to link on is varchar 20 but whatever I am doing in excel always getting error when linking tables in crystal 'not the same type.'.
How to code this in the excel sid