I 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 am trying to import excel sheet, got an error like "
The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data"
I have given all necessary permissions but no luck..
this is me once again moving around data access. my problem now hide in the import process of an excel file that would be inserted into sql db.
the problem is the excel file may be updated or changed and i have to periodically import it and perform the process but I still cant check or compare between the two Data Source (excel, sql) as I violate the entity integrity (PK)
i found a kind of stupid approach that each time i want to import the file i will empty the table then re-insert the data, but at this step a new problem raise that other tables are !engaged! with it ... so i will violate the referential integrity (FK)
i looking for solution to compare between two sources for each tuple / row, ignore the existing one and insert the new
[Code]....
i am facing the error
The Microsoft Jet database engine could not find the object 'MyDataFile$'. Make sure the object exists and that you spell its name and the path name correctly.
below is my code, i am exporting my excel sheet in HTML format. in case of importing i am facing the above mentioned error.
[code]...
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 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);
I have an issue while importing the data froma customized gridview to an excel sheet .It prompts me to save the excel sheet and excel sheet is getting saved on my machine but while opening the excel sheet I am getting an error as follows and it opens as blank.Could some one tell me what the issue is.I have given the complete code to import excel sheet and error while I open it as well. In-addition to this suprisingly another issue too I have encountered when I am trying to export.
While I am trying import by clicking on Import only the datas in the CurrentPage is getting exported and remaining datas are not..I mean ..If my GridView shows 50 records at a time only these records are getting imported and remaning records are not
public static void ExportToExcel(DataTable dtFull)
{
string fileName = string.Empty;
OpenFileDialog fileDlg = new OpenFileDialog();
fileDlg.DefaultExt = "xls";
fileDlg.Filter = "Excel files (*.xls)|*.xls";
fileDlg.CheckFileExists = false;
// fileDlg.
fileDlg.Title = "Choose XLS";
if (fileDlg.ShowDialog() == DialogResult.Cancel)
return;
fileName = fileDlg.FileName;
try
{
if(System.IO.File.Exists(fileName))
{
FileStream fs = System.IO.File.OpenRead(fileName);
fs.Close();
}
}
catch
{....................
I have a table with 100 records. I need to import extra 50 records in the same table. So from 101 to 150 records should insert the data which is present in excel Simply I want to import 50 records from Excel to Table without disturbing the first 100 records.
View 5 RepliesI 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?
I am trying to insert data from excel file into sql server database table. which is working fine.. But when i tried it in table which has primaryKey As Autonumber and date as getdate(). its not inserting values in rows?
View 10 Repliesi am developing an appilication using asp.net 3.5 with c#.net and SqlServer 2005 as backend databse.
in my application i have to import the data from excel file to database. the fields in excel file and fields in databse table are same. i just want to import all data to that database table.
when uploading an excel file i am receving this error.
[code]....
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 am following article in aspsnippets to upload excel file ,it is working fine for 2007 format of excel but displaying error "External table is not in the expected format." for 2003 format
<add name = "Excel03ConString" connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel 8.0;HDR=YES'"/>
<add name= "Excel07+ConString" connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 12.0;HDR=YES'"/>
string extension = Path.GetExtension(FileUpload1.PostedFile.FileName);
string conString = string.Empty;
[Code].....
[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 .
i have an application with an upload page and require it to be able to upload large files. Everything works well with small files but when it comes time to uploading bigger files i am having troubles... I added <httpRuntime maxRequestLength="2048576" /> in web config but still when i tried uploading a 500MB file it crashes after a few minutes with an error application offline or unavailable after some searching i went to my application in IIS 7.0 went in "Request Filtering" > "Edit Feature Settings" and changed the default value "Maximum allowed content length (Bytes)" to 1500000000 and restarted my app now i do not get the application offline error after i start my upload but instead in seems to go in a never ending loop.. I tried with Google chrome and it displays the percentage of the upload but every time it reaches 100% it restarts back to 0%.
EDIT: It is not a never ending loop after like 40 minutes i get "The webpage is not availale" same message i used to get before i made the changes
I am using the fileupload control to upload an excel file to a server, but I am getting a
"Access to the path '\<server>importResponses.xls' is denied" when I try to use fileUploader.SaveAs(filepath). The filepath I use is \<server>importResponses.xls, so I am actually saving it to a share on a different server.My environment consists of a web server and a database server. I am trying to upload the excel file to a share on the database server. A stored procedure then takes that excel file and imports the data from it into a table. So the problem isn't with being unable to save a file to a share on the web server, but it's a problem with being unable to save a file to a share on the database server. It used to work, but now it doesn't and I have no idea why. What process(es) on the database server do I need grant write access for in order for the fileupload control to successfully save the excel file?Right now, I only have the Network Service account with read/write access to the share on the database server. I tried adding other accounts, such as the ASPNET and IUSR_<server name> accounts, but nothing seems to work.The web application that does the actual uploading is configured like this:
<authentication mode="Windows"/>
<identity impersonate="true"/>
Could that have anything to do with it?If you're asking why I'm trying to save an excel file on the database server instead of on the web server, this was the only way I got this to work. If anyone has a better suggestion on how to programatically import excel data into a SQL table, I am all ears.
I created my application using asp.net binded to MySQL database and every thing is working fine.
I used connection strings and normal connections defined in the code as mysqlconnection.
I uploaded all pages and database to the webserver, but the data is not accessed.
I have to modify the web.config file but what changes I have to make?
While uploading file on live server i get this error.
System.UnauthorizedAccessException: Access to the path 'xxxwork-max.comTelecomimageslogo.gif' is denied.
ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.
<identity impersonate="true"/> promotes for user name and password each time i select
file uploading.
[URL] - with reference to this post grant permissions to NETWORK SERVICE user will solve the problem but granting permissions will
I've got a simple (inline) ASPX page that is ouputting XML.
I want to import this XML into Excel 2007 using Data | From Other Sources | From XML Data Import.
If I specify the URL for my APSX page Excel opens the result into the Text Import Wizard :(
If I open my URL directly from Notepad, save the content to a file and import that into Excel, its correctly treating is a Xml. why Excel is treating the result as text when is comes from a Url?
Heres the code from the ASPX Page
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Xml" %>
[Code]....
Is there some simple way I am missing to import an Excel worksheet into a datatable using an OleDBConnection and change what row the header is located on? I have HDR=YES in my connection string and that works great when header is on row 1 but the header is actually going to need to be on row 3. I am using the following CommandText:
SELECT [headercol1name], [headercol2name], [headercol3name] FROM [sheetname]
Uploading file using upload control resulted in access denied
does not have write access to 'C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files'.
I gave the access to that particular user using web config :
<identity impersonate="true" userName="username" password="password"/>
but then that resulted in the above error. My intension is to upload the file for a perticulr folder.
I know the path.
I am not able to grant the persmission for the folder from control panel. Is there any work around.
I have been asked to create import functionality in my application. I am getting an excel worksheet as input. The worksheet has column headers followed by data. The users want to simply select an xls file from their system, click upload and the tool deletes the table in the database and adds this new data.
I thought the best way would be too bring the data into a datatable object and do a foeach for every row in the datatable insert row by row into the db. My question is what can anyone give me code to open an excel file, know what line the data starts on in the file, and import the data into a datable object?
Is there a way wherein I could import data from multiple sheets of an excel file?
View 2 Replies