Convert Comma Delimited Text File to XML

I need to convert a comma delimited text file to an XML that can be stored in a SQL Server table.

This is a sample of the text file:
There are 7 columns.
I am storing each col value in the values[] array.

AA.P,  20131227,  76.55,  78.95,  76.55,  78.95,  400
AADR,20131227,37.6,37.6,37.4,37.4,15800
AAMC,20131227,900,906.86,900,902,2100
AAU,20131227,1.13,1.16,1.1,1.15,137300
ACCU,20131227,28.35,28.35,28.28,28.3,3300
ACIM,20131227,62.11,62.11,62.11,62.11,300

This is the code I am using to count the lines:
     int intRowCounter1 = 0;
        FileStream fs1 = new FileStream(pstrSourceFile, FileMode.Open, FileAccess.Read);
        StreamReader sr1 = new StreamReader(fs1);

        string[] headers1 = sr1.ReadLine().Split(new char[] { ',' });
        string[] values1;
        string line1;

        while ((line1 = sr1.ReadLine()) != null)
        {
            intRowCounter1++;
        }

This is the code I am using to read each line:

FileStream fs = new FileStream(pstrSourceFile, FileMode.Open, FileAccess.Read);
        StreamReader sr = new StreamReader(fs);

        string[] headers = sr.ReadLine().Split(new char[] { ',' });
        string[] values;
        string line;
       
        //sr.ReadLine(); // Skips first line
        // Run "usp_getEODExtract" for each line

        while (intRowCount < intRowCounter1) // Skips 2 rows out of 1820 in AMEX EOD text file
   
        {
            line = sr.ReadLine();
            values = line.Split(new char[] { ',' });
            values[values.Length - 1] = values[values.Length - 1].Trim(new char[] { '"' });

Where do I go from here?

Thank you
DovbermanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MattiCommented:
MSAccess 2013 does this with it's import/export tools and you can connect to SQL from it.
No need to code just a few mouse clicks.

Matti

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DovbermanAuthor Commented:
I will try and then give you feedback in 2 hours.

Thanks
DovbermanAuthor Commented:
I tried it on MS Access 2010.  It works perfectly.  I can also save the conversion as a job.

Thanks,
DovbermanAuthor Commented:
Perfect, Thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.