Bulk Query

Question

hello!

please explain me:
- How to store data of Excel file into SQL sever using bulk query ?
- Where to add this query in our web page ?
- Do I need to create it over ASP.NET contol- 'Upload File' ?
:)

Khan Abrar Ahmed · Answer

Hi Refer these links http://sqlandme.com/2013/04/15/sql-server-import-data-from-excel-using-t-sql/ http://www.66pacific.com/sql_server_import_from_excel.aspx http://www.mssqltips.com/sqlservertutorial/203/simple-way-to-import-data-into-sql-server/ http://support.microsoft.com/kb/321686