Excel Lookups Do Not Return Leading Zeros

When utilizing the Attribute Lookup feature with an Excel data source, cells containing leading zeros might not retain these zeros in the returned results to the client.

Leading zeros can be retained by formatting the data in the select statement for the lookup. The example below pads the zip code field with leading zeros if they are not returned:

SELECT Customer, Address, City, State, FORMAT(Zip,'00000') as ZipCode FROM [Sheet1$] WHERE Account = [%Account No.%]