step 1 ) upload your excel file to temp file on server step 2) your web app run aspose to read excel file and save them into database step 3) finish
see www.aspose.com On Fri, Feb 25, 2011 at 7:57 AM, Gourav vishnoi <[email protected]>wrote: > Hi All, > I am still not clear HOW to Upload Data into Sql Server web application.. > there is Thousands of Record in my Excel Sheet..Please Guide me...... > > > On Thu, Feb 24, 2011 at 10:53 AM, Gunawan Hadikusumo < > [email protected]> wrote: > >> use aspose.....to read the excel and push the data to server..... >> >> >> >> >> On Thu, Feb 24, 2011 at 6:27 AM, Gourav vishnoi < >> [email protected]> wrote: >> >>> Thanks Cesar , >>> *But i didn't understand have you and small or dummy apllication or any >>> web referance for clearify...* >>> * >>> * >>> On Wed, Feb 23, 2011 at 2:18 PM, Cesar Perez Ramirez <[email protected] >>> > wrote: >>> >>>> Hi How do u do ? >>>> Hope It Helps .... >>>> >>>> You can call an Stored Procedure after Uploading the file , you can put >>>> this code into your SP >>>> >>>> BULK >>>> >>>> INSERT >>>> [MySqlServerTable] >>>> >>>> FROM >>>> 'c:\YourDirectory\AndFileName.csv' >>>> >>>> WITH >>>> >>>> ( >>>> >>>> FIRSTROW >>>> = 2, --This Means that the insert will starts at the second row >>>> because the first have the names of the columns in this example >>>> >>>> FIELDTERMINATOR >>>> = ',', >>>> >>>> ROWTERMINATOR >>>> = '\n' >>>> >>>> ) >>>> the columns in the Sheet must have the same structure as the Sql Table >>>> . >>>> >>>> >>>> >>>> On Tue, Feb 22, 2011 at 8:36 PM, Gourav <[email protected]>wrote: >>>> >>>>> Hi ALL, >>>>> Actually i have a Standard version or Format of Excel sheet. >>>>> i want to upload this Excel sheet in SQL Server through my Web >>>>> application.i searched(googling) many application but didn't get >>>>> solution as er my requirement SO pls guide me.. >>>>> >>>>> AS per i think..pls refer attached .JPEG file. >>>>> i) Suppose there is three Field in my Excel sheet. Firstly i upload >>>>> this excel sheet. >>>>> ii)After upload right sides Drop down will be populate that Three >>>>> Field (Column).which is in my excel sheet >>>>> iii) user can map these field..corresponding to left side drop down >>>>> which is comes from sql DB >>>>> iv) Then finally upload to SQL.. >>>>> >>>>> CAN IT POSSIBLE >> ?? Becoz i seen these all functionality in an >>>>> application.and that application upload 10000 rows within 2 Minute. >>>>> i'll wait for reply >>>> >>>> >>>> >>> >>> >>> -- >>> Warm Regards :- >>> Gourav Vishnoi >>> +91-9871157845 ( M ) >>> >> >> >> >> -- >> johnhadikusumo.blogspot.com >> www.miniadverts.com.au >> www.livingsuburb.com.au >> www.satuindonesia.com.au >> www.redballoontravel.com >> www.myfile.us >> www.highheelsandwig.com >> >> > > > -- > Warm Regards :- > Gourav Vishnoi > +91-9871157845 ( M ) > -- johnhadikusumo.blogspot.com www.miniadverts.com.au www.livingsuburb.com.au www.satuindonesia.com.au www.redballoontravel.com www.myfile.us www.highheelsandwig.com
