I am using SQL Server 2012.
I need to import an Excel File and a CSV file into SQL Server tables.
I Excel file is "C:\Data\Cust_Data.xlsx". The CSV is "C:\Data\Cust_Data.CSV".
The name of the SQL Server table where both CSV and Excel file should be uploaded is "Customers".
The database is "MainData". The CSV, Excel file and SQL Server table have the same fields.
Could some one please write a Stored procedure in SQL Server to import the Excel file into the SQL Server table.