VB with EXCEL's seamless connection
no vote
VB connect seamlessly with EXCEL:
' After receiving the data from the Excel file, inserting records to a SQL Server data table
Dim dataTable1 As DataTable = New DataTable()
Dim sqlDA1 As SqlClient.SqlDataAdapter = New SqlClient.SqlDataAdapter ("SELECT sectors, throughout the task,
completed this year, compared to complete, [%],[for annual completion of comparable growth rate] FROM Rwb" sqlcon)