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 )

Reply via email to