If you are configuring a lookup to point to a CSV file, you may encounter formatting issues. By default, if the columns are not specified what type they are, the Microsoft Text File Driver will try to automatically interpret it. This process can guess incorrectly, resulting in improperly formatting results from the lookup. You will need to edit the Schema.ini file appropriately.
A Complete description of modifying this is available at Microsoft's website: