Clone or download the repository to your local machine. Open the solution file (ExcelImporter.sln) in Microsoft Visual Studio. Build the solution to restore NuGet packages and compile the project.

ExcelToSQLServer is a productivity tool that can automatically import excel into SQL Server. Automation is its main feature, because it can automatically generate table information based on excel to ...

Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server. To do this, we’ll use an SQL Server Agent Job.