Errors with Export to CSV From DB

[MumbleB]

Hi Guys. I have managed to get some code to export data in my Access DB to a CSV file. Now, I have two small issues. 1. I want to mark all the records as they are exported to Y in a column named exported and only export all the records marked as N. Anybody have a suggestion on how I could do this in the export code? 2. When I open the CSV file in Excel I get a few errors. First error says that the file is in a different format than the one specified by the extention. It allows you to continue and then comes up with error "Cannot read the 1st record. The it reports yet another error which says that Excel has determined the file to be a SYLK file but not load it" but it still imports the data into Excel. Any ideas on how I get past this? Code below:

    private void toolStripButton2\_Click(object sender, EventArgs e)
    {
        
        StreamWriter sw = new StreamWriter(@"C:\\nefz.csv", false);
        DataTable dt = m\_dtCallCentre;
        int iColCount = dt.Columns.Count;
        for (int i = 0; i < iColCount; i++)
        {
            sw.Write(dt.Columns\[i\]);
            if (i < iColCount - 1)
            {
                sw.Write(";");
            }
        }
        sw.Write(sw.NewLine);
        foreach (DataRow dr in dt.Rows)
        {
            for (int i = 0; i < iColCount; i++)
            {
                if (!Convert.IsDBNull(dr\[i\]))
                {
                    sw.Write(dr\[i\].ToString());
                }
                if (i < iColCount - 1)
                {
                    sw.Write(";");
                }
            }
            sw.Write(sw.NewLine);
        }
        sw.Close();

    }

[Bino B]

u can manually xport the data in MDB as CSV, from import/export option in MS Access. And i guess from there u can update the coluns to y/n thru ur application.

Cheers Bino www.codepal.co.nr

[MumbleB]

Yeah, I guess I can do that but that is not what I want to do. I want to do the export through code. This will be done by a user once I get it to work. Anybody else able to help out maybe or suggest something?

[MumbleB]

Can anybody else please have a look at the Original post please?