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 )
