How To insert Excel file data into MS SQL table

[Madhuraj (Madhura Tendulkar)]

@rakeshadn

Find the attached xaml file FYR

Replace your connection string and file path.

PFB SQL Table creation Query

Create Table ExcelToTbl
(
From_Currency NVarchar(100),
To_Currency NVarchar(100),
Conversion_Rate Decimal(10,5),
Conversion_Date Date
)

ExcelToTable.xaml (8.8 KB)

Regards
Madhura