Does anyone know how to import datatable into an SQL Server?
I have this task to import excel file to grid control and what i did was use oledb to parse excel file to datatable and then bind it to GridControl. How can i then import this datatable to an sql server? thanks in advance
1 Reply
You can import excel data directly with ssms
https://learn.microsoft.com/en-us/sql/relational-databases/import-export/import-data-from-excel-to-sql?view=sql-server-ver16
Import data from Excel to SQL Server or Azure SQL Database - SQL Se...
This article describes methods to import data from Excel to SQL Server or Azure SQL Database. Some use a single step, others require an intermediate text file.