Excel Importer is a versatile C# Windows Forms tool that simplifies data import from Excel spreadsheets into SQL Server databases. This project was created as a challenge to handle data import from multiple worksheets within Excel files and seamlessly insert it into the user's SQL Server database. With Excel Importer, users can select specific worksheets, ensuring flexibility and precision in data handling. Whether you're dealing with complex financial data or simple lists, Excel Importer streamlines the process, making data migration a breeze. Try it now to optimize your Excel-to-SQL data import workflow!
Before you begin, make sure you meet the following requirements:
- Be connected to a SQL Server, which contains a database called
Desafio_Planilhafor importing. - Be an authorized user in this domain.
Follow these steps to import data from the spreadsheet into the database:
-
Clone this repository to your local environment:
git clone https://github.com/your-username/your-project.git
-
Set the SQL Connection informations in the connectionString.txt file, replacing the respective fields with your available SQL connection, following the [Requirements].
-
Run the
DesafioImportaExcel.exeshortcut, located in the main project folder, and follow the instructions to select the spreadsheet and the type of data to import (Cliente or Debitos). -
The application will import the data from the spreadsheet into a database on the server, if desired.
-
The data will be available in the database for queries and analysis.
- Note: This project is currently for internal use and requires specific SQL Server configuration. Ensure that your environment meets these requirements before proceeding.
-
pt.stackoverflow.com - Qual a melhor forma de fazer a leitura de um arquivo .xls?
-
I also accessed the websites and information of other libraries mentioned in the sources, but since I didn't use them in the code, there is no need to provide links to all compared libraries.