xlsxdb

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.

TODO

• 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)