Executing the cross-connection query user interface on between Salesforce and Excel data sources returns the error below. It usually happens when one selects a Salesforce object with many fields.
Example errors are shown below:
A)
Lookup Error
Unknown column '' in ''. Make sure that the table is fully qualified, and that the defined table alias is also included in the column name. Check that column names are spelled correctly.
-OR-
B)
Cross-Query Database Error: Unknown column ‘Account.P2Express_MID_c’ in ‘on clause’. Make sure that the table is fully qualified, and that the defined table alias is also included in the column name. Check that column names are spelled correctly.