OleDbException (0x80004005)

Posted 31 January 2013 - 07:36 AM

I'm developpin an aplication to my boss,i get an OleDbException (0x80004005) when i'm trying to implement this code:http://www.dreaminco...&showentry=3238 , so i'm really need a help to solve it, this is the Exception:fedda$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long

Re: OleDbException (0x80004005)

Posted 01 February 2013 - 02:01 AM

i have renamed the sheet Sheet1 but it's still the same Exeception,i have have read about this exception that it's a BOGUE : Le pilote ODBC Excel ignore les paramètres FirstRowHasNames et Header : http://support.micro...om/kb/288343/fr,but i was wondring if there is any solution for this Exception cause i really need it since i'm working in an application on MVC Model , and i have to import the Excel data in my data base,
and when i'm trying to test this code:http://www.dreaminco...&showentry=3238:

Upload Controller

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Data.OleDb;
using System.Data;

Re: OleDbException (0x80004005)

Posted 01 February 2013 - 06:57 AM

it dosn't work with the apostrophes but i find the solution that i have to name the sheet inside the excel document too not just the excel document with sheet1. (it's very funny Exception, i thought that's the probleme of oledb OMG)