tag:blogger.com,1999:blog-7805972021499203804.post2549192120992256833..comments2023-10-30T06:24:14.411-07:00Comments on ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview: how to Import data from EXCEL to SQL Database in ASP.NETSuresh Dasarihttp://www.blogger.com/profile/01337689983379917267noreply@blogger.comBlogger196125tag:blogger.com,1999:blog-7805972021499203804.post-7443814718775553992019-07-12T03:36:40.053-07:002019-07-12T03:36:40.053-07:00Hello Sir,
How to import excel sheet with images a...Hello Sir,<br />How to import excel sheet with images and data to database using asp.net c#?<br />I have reffered the given example but it contains only data not images ,i want to import the excel with images.<br />Please help me Sir,<br />ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-29247259194228222372017-11-06T07:27:27.228-08:002017-11-06T07:27:27.228-08:00Hey Can you please help me same code with help of ...Hey Can you please help me same code with help of stored procedure..<br />I want to perform this task with the help of stored procedure, because i have to insert some other data too. <br />Thanks in advance,<br />You can replay on this email id: akiporwal99@gmail.comAnonymoushttps://www.blogger.com/profile/11722951012947373262noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-21266609704232861842017-11-06T07:05:53.171-08:002017-11-06T07:05:53.171-08:00Thanks a lot !! Appreciated .. solved my work to a...Thanks a lot !! Appreciated .. solved my work to a great extend...<br />Thanks , its working for me..Anonymoushttps://www.blogger.com/profile/11722951012947373262noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-65085354258600527202017-10-11T07:34:19.127-07:002017-10-11T07:34:19.127-07:00i tried this demo and run very well but sir when i...i tried this demo and run very well but sir when i applied this code for live server that time i got error like The Microsoft Office Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data. <br />and i read your article on this error but i never uploaded excel file in any folder.so varun pujarahttps://www.blogger.com/profile/09767424979298298274noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-91101759333859918702017-03-24T04:12:09.780-07:002017-03-24T04:12:09.780-07:00hello sir,
i faced error like
The Microsoft Acces...hello sir, <br />i faced error like<br />The Microsoft Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data. <br />so please give me a solution of this error.varun pujarahttps://www.blogger.com/profile/09767424979298298274noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-71681367505791955442017-03-10T01:48:34.739-08:002017-03-10T01:48:34.739-08:00The Microsoft Access database engine cannot open o...The Microsoft Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.<br /><br />as i change the permission still i get same error.. what to do ??Anonymoushttps://www.blogger.com/profile/18258881903288850046noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-23167299872540343262017-02-16T04:02:11.835-08:002017-02-16T04:02:11.835-08:00Hi Suresh,
Can we do the same to MySQL instead of ...Hi Suresh,<br />Can we do the same to MySQL instead of Sql serverAnonymoushttps://www.blogger.com/profile/01398918454548635719noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-91351018017746918652016-08-28T04:44:32.086-07:002016-08-28T04:44:32.086-07:00thank you soo much suresh.... your post are very i...thank you soo much suresh.... your post are very informative and I am trying to learn lot of things from them. GAURAVhttps://www.blogger.com/profile/07099684918085868062noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-68868284475911554452016-07-04T11:51:46.553-07:002016-07-04T11:51:46.553-07:00Hi suresh i am getting this error please solve the...Hi suresh i am getting this error please solve the problem"External table is not in the expected format".Anonymoushttps://www.blogger.com/profile/03610322048482501261noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-91080570324191014742016-06-28T04:01:58.674-07:002016-06-28T04:01:58.674-07:00if i have data in two sheet named sheet1 and sheet...if i have data in two sheet named sheet1 and sheet2 then what will be the code.Anonymoushttps://www.blogger.com/profile/16043075417371366016noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-65622916480281373002016-06-25T02:27:19.569-07:002016-06-25T02:27:19.569-07:00To get rid with this error- The Microsoft Office A...To get rid with this error- The Microsoft Office Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.<br /><br />Make a folder in root directory of your project then use full path of file.<br /><br />string FileName = FlUploadcsv.FileName;<br />string path = string.Concat(Web-blogshttps://www.blogger.com/profile/14222598652075198239noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-28482619347009951772016-06-25T02:10:30.805-07:002016-06-25T02:10:30.805-07:00The Microsoft Office Access database engine cannot...The Microsoft Office Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data. <br /><br /><br />why im getting above errorWeb-blogshttps://www.blogger.com/profile/14222598652075198239noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-69111616858734971242015-08-21T04:58:00.489-07:002015-08-21T04:58:00.489-07:00Hi..
i am new to asp.net,
in my project i have...Hi..<br /><br /><br /><br />i am new to asp.net,<br /><br />in my project i have a dropdownlist="values to be inserted into database"<br />fileupload="file(excel) to be inserted into database" <br />submit button<br /><br />how do i do bulk insertion along with the values of the dropdownlist?<br /><br />i have tried with sqlbulkcopy but it does't work for me ...<br /><br /Anonymoushttps://www.blogger.com/profile/04918431274804281149noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-4694500063170905152014-07-05T23:30:59.262-07:002014-07-05T23:30:59.262-07:00how to Import data from EXCEL to MS Access Databas...how to Import data from EXCEL to MS Access Database in ASP.NET , Please give sample to me (sankaradass@gmail.com)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-27097690084518681102014-05-29T01:24:51.134-07:002014-05-29T01:24:51.134-07:00hi suresh sir,
i am gettting an error which state...hi suresh sir,<br /> i am gettting an error which states that <br />"the Microsoft Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data" <br />could u pleasse reply to sravan.chaganti@gmail.comkumarhttps://www.blogger.com/profile/11171230430485808367noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-9538800364662830952014-05-19T02:16:51.934-07:002014-05-19T02:16:51.934-07:00Hi,
I have try this code, but get following error ...Hi,<br />I have try this code, but get following error msg.<br /><br />The Microsoft Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.Cool_Codinghttps://www.blogger.com/profile/16488272202444444190noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-57308735117272831502014-05-16T01:31:47.410-07:002014-05-16T01:31:47.410-07:00Hi, tnx for the code, now, i dont understand where...Hi, tnx for the code, now, i dont understand where i must to write the connection and path to my sql database and table, can u help me with this?? tnx a lot !!!Administradorhttps://www.blogger.com/profile/08440729297859662370noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-47488010065400825502014-05-09T23:22:32.243-07:002014-05-09T23:22:32.243-07:00it showing the data from excel sheet in gridview b...it showing the data from excel sheet in gridview but data is not inserting into database table why?..any one solve this problemAnonymoushttps://www.blogger.com/profile/15877676866895430894noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-80448063667671632112014-05-01T04:46:21.006-07:002014-05-01T04:46:21.006-07:00Cannot update. Database or object is read-only.Cannot update. Database or object is read-only.Anonymoushttps://www.blogger.com/profile/12052069096210584579noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-27996805745028776602014-04-22T10:52:53.115-07:002014-04-22T10:52:53.115-07:00Hi,
I'm using the same code to import data bu...Hi,<br /><br />I'm using the same code to import data but along with the code a few rows with NULL values are also copied each time i do an import. I'm not able to figure what the problem is.shilpahttps://www.blogger.com/profile/09898805238470092119noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-31592095700240461432014-03-23T07:25:10.302-07:002014-03-23T07:25:10.302-07:00To get rid with this error- The Microsoft Office A...To get rid with this error- The Microsoft Office Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.<br /><br />Make a folder in root directory of your project then use full path of file.<br /><br /> string FileName = FlUploadcsv.FileName;<br /> string path = Anonymoushttps://www.blogger.com/profile/17991306930855672526noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-27566437675298050452014-03-22T00:18:24.107-07:002014-03-22T00:18:24.107-07:00hi suresh!
The Microsoft Office Access database en...hi suresh!<br />The Microsoft Office Access database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly.<br /><br />same error i m getting<br />i have checked everything but error still occur..<br />please help me outvarun khandodiyahttps://www.blogger.com/profile/11980314841874890777noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-67547200700423438982014-03-10T01:16:25.141-07:002014-03-10T01:16:25.141-07:00Hello,
how can we Import Changing Excel data(data ...Hello,<br />how can we Import Changing Excel data(data here changes every second) into SQL DB?Raj666https://www.blogger.com/profile/16596457099746642567noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-46291195470820032132014-02-10T03:43:47.041-08:002014-02-10T03:43:47.041-08:00hai suresh
i want code for openoffice calc t...hai suresh<br /><br /> i want code for openoffice calc to sql server,pls help meAnonymoushttps://www.blogger.com/profile/03354609633933046149noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-70861882235720598992014-01-29T00:34:07.524-08:002014-01-29T00:34:07.524-08:00excelConnection.Open(); error
please help error ...excelConnection.Open(); error <br /><br />please help error description<br /><br />The Microsoft Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.Addhttps://www.blogger.com/profile/10230217850668949973noreply@blogger.com