Subject:Convert .CSV file to XML Author:Donald Norris Date:26 Sep 2006 02:30 AM Originally Posted: 26 Sep 2006 02:31 AM
SS2007 does not seem to know how to handle if a data record in a .CSV file is empty. I use a tab(09) to separate fields. If a data record has 2 tabs together SS2007 does not correctly intrepret this as an empty field. As a result all fields after this are off by one.