Releases: robinwilson16/ExcelSQLImporter
Version 1.0.2
Fixes an error that may lead to an error saying WinSCP can't be found
Version 1.0.1
This release adds the option for specifying a prefix for the SQL table that is created and an option to get the table name from either the Excel worksheet or file name which may be useful to avoid importing different files as Sheet1
.
Version 1.0.0
This is the initial version which has been tested with a large Excel file where column contents exceeded 15k characters and various data types so should work for any file but if you notice any bugs please let me know and I will get them fixed.
amd64 is for Intel/AMD x86/x64 Processors and devices running Windows
arm64 is for Snapdragon Qualcomm Oryon Processors.
If you are not sure which one you need it is probably the ExcelSQLImporter-amd64.zip
file.
Extract the file, edit appsettings.json to enter your Database, FTP and Excel File Settings and Paths.
Click to run the file.
Optionally if you wish to use this to import multiple Excel files then specify the name of the json config file after the end of the exe so:
ExcelSQLImporter.exe nameofconfigfile.json
Task Scheduler in Windows can be used to run this task on a schedule such as each night.