A tool to help inserting rows from Excel worksheet direct into a database.
It's necessary to provide a .env file in the same directory of executable file, containing the connection string inside CONNECTION_STR.
Example:
CONNECTION_STR=server=xxx;user id=xxx;password=xxx;initial catalog=xxx;The worksheet file should be named with the same name of destiny table.
- Generate SQL code, when table does not exist;
- Write Logs;
- Enhance CLI;
- SetOrdinal;
- If column is not in database, ignore it;
- When cell has no value, insert it as null (check if is PK)