data import from excel to Data grid view

[Lost User]

Hi Experts i am working in Winform using VS 2005 and SQL Server 2005 in C#.NET. i have a project which have import data from Excel Sheet. but the data in Excel sheet is very Large Scale like 350000 Record. Then it take time to import the data from excel sheet. then can you suggest me how to Imports Such type of Bulk data . Thank u Dinesh

[Abhinav S]

Did you search on the internet for a solution? I did and found this.

My signature "sucks" today

[Lost User]

But i want to import Bulk data in Lacks and if i want to paging apply on importing data then have you any idea how i apply paging in import data in select Query. Thank u

[Ramkithepower]

Use DTS or SSIS transformation. It generally finishes the work in seconds. Build is easy too.

Jack Sparrow -------------------------------------- Defeat is not the worst of failures. Not to have tried is the true failure.