Help to read the excel file.

FaridMasood -2 Junior Poster in Training

15 Years Ago

Here i am attatching the source code and the excel file. When i use this code it generates the error , "The external table is not in correct format'.

Code:

private string StrConn = "";
    OleDbDataAdapter da;
    DataSet ds = new DataSet();
StrConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"";
            da = new OleDbDataAdapter("SELECT [Response Code], [Transaction ID] FROM [Download20080831-112615$]", StrConn);
            da.Fill(ds);
        }

If you want to test i have also attatched the excel file in zip filder that i am using
One thing however this working to read any other excel file.
Please if someone has any idea help me.

asp.net

This attachment is potentially unsafe to open. It may be an executable that is capable of making changes to your file system, or it may require specific software to open. Use caution and only open this attachment if you are comfortable working with zip files.

File.zip (108.51 KB)

1 Contributor
0 Replies
120 Views

Be the first to reply

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.