I received this error after I have deployed my application in the server (win 2003) but in my development pc it is working.
Code:
External table is not in the expected format.I can upload even the excel files is more than 30MB in file size.
I come from MVC side, where these things make more sense (of course just because I know a bit about it) and my webforms are still sucky sucky.
I got a page where I want the user to upload a file (Excel).
Not too worried about the upload timing out, but after uploading this file will be processed (time & attendance data to be written to the database)
So what I'd like to happen is everything happen asynchronously with the page being updated as the file are being processed.
Also, I'm not sure.. won't I need excel on the server to have my code read the excel file?
It cant be more simple. However I have tried a lot of examples and none of them have been working.
I have a very simple Excel file. I want to post these data in a gridview, Column A, B and C all placed in the Sheet1 and the file name is Book1.xls.
I have a web page which I have created to allow users to upload excel file sheet and thus these sets of data will be inserted into the database. However, as I was testing out, I realized that if the excel file is too large (i.e. mulitple sheets, > 5 sheets) , the portal may not be able to handle the large amount of data and displayed error message like the connection is reset. I tried it with only less than 5 sheets it will be fine. Any idea if there are any codes or mechanism which could solve this problem?
View 6 RepliesI am a beginer in Developing ASP.NET webpage.
I want to restrict duplicates while uploading the excel data and to inform the user that the perticular cell in excel contains duplicate value which is already exist in Sql Database.(Duplicates should be check in Excel (EMP_ID) against SQL (EMPLOYEE_ID)
SQL DATABASE
Table : Employees
FiledName:EMPLOYEE_ID
Excel DATABASE
Sheet: Sheet1
Column: EMP_ID
Message should display as:user cannot upload the data to with duplicate values. Kindly remove the duplicate fields and re-upload.
What is the efficient way to upload excel data to sql database?excel file consists of 4000 rows..so i need to save these records to sql database in web application,i know only by creating ODBC connection i.e
_path = @"Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=" + _path;
OdbcConnection _xlsConn = new OdbcConnection(_path);
_xlsConn.Open();
OdbcCommand _xlsSelSht = new OdbcCommand("Select " + columns + " FROM [" + _sheet + "$]", _xlsConn);
OdbcDataReader _xlsReader = _xlsSelSht.ExecuteReader();
while (_xlsReader.Read()){.....}
I am looking for best practice for uploading excel data in Sql server 2000 database through asp.net web application. Excel data will be predefined Format with almost 42 columns and out of 42 10 fields are mandatory and rest are conditional mandatory. i.e. if data exists it should be in defined format. I also need to validate for special character, length, specified format and so on.After validating, i need to store valid data into sql server table and provide export to excel functionality for invalid data for exporting in same excel format with indicator to identity the invalid cells.
View 3 Replieswhen uploading an excel file i am receving this error.
[code]....
I'm able to upload and read any excel file to my server prior 2007, when I try an 07 Excel file, i'm getting the following error message:
'microsoft.ace.oledb.12.0' provider is not registered on the local machine'
do I need anything specail on the web server to allow for Excel 07 files? I'm running IIS6 and a Win 2003 server
I am uploading an excel file ( containing int values )using the fileupload control. I need to work on one entire column in the excel sheet.I want to copy contents of the file either in an array or a table and then work on it.Can anybody suggest a better way of working on the excel since .
View 4 RepliesI facing a problem when I upload a file from my side while the application is running in server.
The error shows below:
'C:Excel FilesStaff Directory1.xlsx' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
I want to upload data from an Excel Sheet into my DB. Now my major requirement is, I do not know the header count in the files to be uploaded and they may vary, for example one file may have 3 headers while some may have 6. and I want data of both these files to go into a single DB. That is, I want to dynamically generate columns in my DB, and store these values. So how do I go about achieving this.
View 4 RepliesI am facing some problem while uploading excel sheet upload and connecting it to dataset. The Code works fine in local machine but on website its showing following error.
System.Data.OleDb.OleDbException: Unspecified error at System.Data.OleDb.OleDbConnectionInternal
Below is my code:
string FileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
string Extension = Path.GetExtension(name);
string FolderPath = ConfigurationManager.AppSettings["FolderPathSMS"];
string FilePath = Server.MapPath(FolderPath + FileName);
switch (Extension)
{
case ".xls": //Excel 97-03
s = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FilePath + ";Extended Properties='Excel 8.0;HDR={1}'";
break;
case ".xlsx": //Excel 07
s = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePath + ";Extended Properties='Excel 8.0;HDR={1}'";
break;
}
EDT = new DataTable();
EDT.Columns.Add("MobileNo", typeof(string));
con = new OleDbConnection(s);
con.Open(); // I am getting the error at this point
da = new OleDbDataAdapter("select * from [Sheet1$]", con);
ds = new DataSet();
da.Fill(ds);
string FileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
string Extension = Path.GetExtension(name);
string FolderPath = ConfigurationManager.AppSettings["FolderPathSMS"];
string FilePath = Server.MapPath(FolderPath + FileName);
there is broblum for uploading excel sheet when my application runing on local host but there is no problum on vs enviroment . i am using the following connection string code
strConn =
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + path +
";Extended Properties=Excel 8.0;"
;
[Code]....
i have successfully showed data using puting directpath in to a textbox(e.g, filename=TextBox1.Text;). but the code above is not working. i dont know why.
I have a big excel file , and i want to upload it to server.
on upload_click , i have to do a processing which takes very long time,
because i am finding latitude and longitude from the google by reading that excel file.
and i wanted that when used click on CANCEL button the process should stop.
i have created a thread on upload_click and doing all this stuff in that thread .
when user clicks on CANCEL , i am aborting that thread.
but when user again tries to upload file , i am getting the error that file is in use .
to solve this problem i have to stop aspnet_wp.exe from task manager and have to try again .
Currently I was done to insert data thru upload excel file. May I know, how to UPDATE the existing data using iploading excel file.
View 1 RepliesWhat I am thinking is this? Is it possible for me to upload the data from an excel file to dataset of my application first, so that the user can view the data in a gridview to review it first, before the user strike the save button, to save it in the database. So, that in case there is a problem, the gridview will high light all the data with an error. So the user can easily pull out the excel and correct the data before saving it in the database.
View 4 RepliesI would like to access an Excel 2010 spreadsheet via ASP.NET 4 - what is the best (i.e. straight forward) method to do this? I would like to update the spreadsheet via ASP then read the results of the data from Excel back to a web form.
View 9 RepliesUser's need to "download" an excel sheet with data.
However this sheet need to be created on the fly (user's can check of which data they want exported).
From the user's point of view, it will just be a link "Download Now".
From coding point of view I will have an IList<MyClass> where MyClass say got members like EntryId, FirstName, LastName etc.
I do not want all fields to be dropped into the sheet (so I will need control over that in my code)
This sounds like what I'm after (since I'll always only have one sheet)
Create an HTML document and save it with a .xls extension - Excel will open it and treat it like a native Excel file. This method is very simple and, of course, free - however, it won't allow you to have more than one worksheet in the Excel workbook...
how to parse excel files data in ASP.NET WebForms using C# or ASP.NET MVC using C#?
View 8 RepliesI am wanting to display an excel 2010 document in an asp.net web application. This document uses the new slicer functionality which I want to be available to the user.I know that excel 2010 docs can be used within sharepoint by inserting a web part which uses exceservices.But can it be achieved without sharepoint? Or can it be achieved using the the excelservices API to get the document from shreapoint and then somehow get it to the browser in .net?
View 1 RepliesHow do I bind data from an Excel file named Book1.xlsx in Column A to a dropdownlist? I've tried like this:
Code:
connExcel.Open()
cmdExcel.CommandText = "SELECT distinct BCName From [Sheet1$] where BCName <> '' and ProjectName like 'Total%';"
oda.SelectCommand = cmdExcel
oda.Fill(dt2)
connExcel.Close()
dropdown1.DataSource = dt2
dropdown1.DataBind()
But the dropdown is filled with "System.Data.DataRowView" for all the 5 lines in the dropdown. How do I get the values shown instead of this? It must be some formatting of dt2 I think.
I have a droplist, that I generate from an Excel file.
Code:
cmdExcel.Connection.Open()
dropdown1.DataSource = cmdExcel.ExecuteReader()
dropdown1.DataTextField = "BCName"
dropdown1.DataBind()
cmdExcel.Connection.Close()
I want to add two more options to the droplist:
dropdown1.Items.Add("Select")
dropdown1.Items.Add("All")
But if I do like this they are added after the items from the databind. I want the Select and All as the two first ones and then get the rest from the databind. How do I do that?
When uploading a new DLL for a large web application (dll is around 1mb) IIS throws an error because the DLL is 'in-use', meaning the website is down while the DLL is being uploaded. Is there a way to stop this behaviour?
Also, although I am using Web Applications, not Web Sites, whenever I upload a new DLL it still takes a while for IIS to restart after a fresh upload. I thought this wait was generally only for websites as they need to be compiled by IIS, not Web Applications?