Too many fields defined

Question

0.00/5 (No votes)

See more:

Hi, I'm trying to read Excel File with 40 columns in my web apps ,but after running it ,I got this error.

CSS

Too many fields defined.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Too many fields defined.

My Code is this :

OleDbConnection oleconn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" +
         "Data Source=" + strFilePath + ";Jet OLEDB:Engine Type=5;" +
         "Extended Properties='Excel 8.0;IMEX=1;HDR=NO'");
        DataTable tbl = new DataTable();


        OleDbCommand cmdSelect = new OleDbCommand(@"SELECT * FROM [" + SheetName + "$]", oleconn);
        OleDbDataAdapter ole_adapter = new OleDbDataAdapter();
        ole_adapter.SelectCommand = cmdSelect;
        oleconn.Open();
        ole_adapter.Fill(tbl);
        oleconn.Close();
        ole_adapter = null;
        return tbl;

Posted 26-May-13 18:28pm

Alireza_1362

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2013-05-26T18:36:00

Solution 1

Don't use * for retrieving the columns, rather use the column names with square brackets "[]" like below.
Try with some columns, then go for all.

C#

OleDbCommand cmdSelect = new OleDbCommand(@"SELECT [Column1], [Column2] FROM [" + SheetName + "$]", oleconn);

Posted 26-May-13 18:36pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Alireza_1362 27-May-13 0:52am

Thanks for your answer ,One thing is My Column Format is something like this: 0.0001-0.5000 ,how can I mention them in front of select command ,I have tried in several ways but didn't get correct result

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-May-13 2:05am

I don't get you. Can you explain again ?

Alireza_1362 27-May-13 2:28am

Hi again, I mean my column in excel file is something like this :0.0001-0.5000,0.5001-1.0000
,this is column name ,so in select command I should retrieve data in this way:
"SELECT Country ,[0.0001-0.5000],[0.5001-1.0000] FROM [" + SheetName + "$]" ,but it doesn't work ,I can't even change the column name ,because it's client file. so would you help me ,thanks

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-May-13 2:33am

Is the column name [0.0001-0.5000] ?

Alireza_1362 27-May-13 2:35am

yes

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-May-13 2:58am

With the code you have, what it is fetching for that column ?

Alireza_1362 27-May-13 3:06am

Sorry ,I couldn't get you! in that column there are some numbers only ,the format is like this

0.0001 - 0.5000 0.50001-0.1000
------------------ --------------
34.0000 216.000
56.0000 52.000
I'm trying to get data from these columns in select command

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-May-13 3:08am

No I am asking after executing the query, what you get DataTable ?
The data is not showing or it is throwing some exceptions.

Alireza_1362 27-May-13 3:10am

this is an error:
System.Data.OleDb.OleDbException: '' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-May-13 3:14am

What happens if you remove that column from query and read other columns ?
Is it working ?

Alireza_1362 27-May-13 3:17am

If I read the Country Column only ,it works perfectly ,but If I add those columns as I mentioned above to select commnad ,it gives me an error that I post it for you

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-May-13 3:34am

As from the exception, it is clear that you can't use punctuation and other characters, do you need to change that column name. There are no other solutions to this.

Please request to client about it and change it to a valid name.

Alireza_1362 27-May-13 3:35am

ok ,thanks anyway for your help.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-May-13 3:36am

Most Welcome... :)
Nice talking to you.

Alireza_1362 27-May-13 23:35pm

Nice talking to you too :) ,Thanks

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-May-13 23:37pm

:)