how Import fixed width txt file and its fields are described in a configutation xml file

Try code below

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.IO;
namespace ConsoleApplication1
{
    class Program
    {
        const string inputFilename = @"c:\temp\test.txt";
        const string outputFilename = @"c:\temp\test.xml";
        static void Main(string[] args)
        {
            DataTable dt = new DataTable();
            dt.TableName = "MyTable";
            dt.Columns.Add("Name", typeof(string));
            dt.Columns.Add("Num1", typeof(int));
            dt.Columns.Add("Num2", typeof(int));
            dt.Columns.Add("Num3", typeof(int));
            StreamReader reader = new StreamReader(inputFilename);
            string inputLine = "";
            while ((inputLine = reader.ReadLine()) != null)
            {
                if (inputLine.Trim().Length  > 0)
                {
                    string[] inputArray = inputLine.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
                    dt.Rows.Add(new object[] {
                       inputArray[0],
                       int.Parse(inputArray[1]),
                       int.Parse(inputArray[2]),
                       int.Parse(inputArray[3])
                    });
                }
            }
            DataSet ds = new DataSet();
            ds.DataSetName = "MyDataSet";
            ds.Tables.Add(dt);
            ds.WriteXml(outputFilename, XmlWriteMode.WriteSchema);
        }
    }
}

---

jdweng