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 )
