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
