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
