TSQL插入发电机和流道采用Excel作为输入

The main script scans recursively a predifined directory uses an excel file for input takes the sheet name as a table name and generates sql inserts using the first column it finds the file to write the sql inserts by search for WorkSheetName.TableInsert.sql pattern in a predifned SqlInstallDir, where the sql install files are situated , if a TableName.TableInsert does not exist it creates it in a preconfigured director. After each sql insert file is generated it is ran against a predified database and the output stored into a log file

ExcelToMSSqlInsert.0.5.0\ConcatenateAll.bat
ExcelToMSSqlInsert.0.5.0\Configurator.pm
ExcelToMSSqlInsert.0.5.0\DbName.lnk
ExcelToMSSqlInsert.0.5.0\docs\ExcelToMSSqlInsert.0.5.0.Features.txt
ExcelToMSSqlInsert.0.5.0\docs\ExcelToMSSqlInsert.0.5.0.License.txt
ExcelToMSSqlInsert.0.5.0\docs\ExcelToMSSqlInsert.0.5.0.TODO.txt
ExcelToMSSqlInsert.0.5.0\exceltomssqlinsert\
ExcelToMSSqlInsert.0.5.0\exceltomssqlinsert\
ExcelToMSSqlInsert.0.5.0\ExcelToMSSqlInsert.cmd
ExcelToMSSqlInsert.0.5.0\ExcelToMSSqlInsert.ini
ExcelToMSSqlInsert.0.5.0\ExcelToMSSqlInsert.pl
ExcelToMSSqlInsert.0.5.0\FileHandler.pm
ExcelToMSSqlInsert.0.5.0\ImportIntoGoogleCode.cmd
ExcelToMSSqlInsert.0.5.0\input\
ExcelToMSSqlInsert.0.5.0\input\
ExcelToMSSqlInsert.0.5.0\lib\ascii.html
ExcelToMSSqlInsert.0.5.0\lib\OLE-Storage_Lite-0.19\OLE-Storage_Lite-0.19\Changes
ExcelToMSSqlInsert.0.5.0\lib\OLE-Storage_Lite-0.19\OLE-Storage_Lite-0.19\lib\OLE\Storage_Lite.pm
ExcelToMSSqlInsert.0.5.0\lib\OLE-Storage_Lite-0.19\OLE-Storage_Lite-0.19\Makefile.old
ExcelToMSSqlInsert.0.5.0\lib\OLE-Storage_Lite-0.19\OLE-Storage_Lite-0.19\Makefile.PL
ExcelToMSSqlInsert.0.5.0\lib\OLE-Storage_Lite-0.19\OLE-Storage_Lite-0.19\MANIFEST
ExcelToMSSqlInsert.0.5.0\lib\OLE-Storage_Lite-0.19\OLE-Storage_Lite-0.19\META.yml
ExcelToMSSqlInsert.0.5.0\lib\OLE-Storage_Lite-0.19\OLE-Storage_Lite-0.19\README
ExcelToMSSqlInsert.0.5.0\lib\OLE-Storage_Lite-0.19\OLE-Storage_Lite-0.19\sample\README
ExcelToMSSqlInsert.0.5.0\lib\OLE-Storage_Lite-0.19\OLE-Storage_Lite-0.19\sample\smpadd.pl
ExcelToMSSqlInsert.0.5.0\lib\OLE-Storage_Lite-0.19\OLE-Storage_Lite-0.19\sample\smpaddF.pl
ExcelToMSSqlInsert.0.5.0\lib\OLE-Storage_Lite-0.19\OLE-Storage_Lite-0.19\sample\smpadd_a.pl
ExcelToMSSqlInsert.0.5.0\lib\OLE-Storage_Lite-0.19\OLE-Storage_Lite-0.19\sample\smplls.pl
ExcelToMSSqlInsert.0.5.0\lib\OLE-Storage_Lite-0.19\OLE-Storage_Lite-0.19\sample\smplls_a.pl
ExcelToMSSqlInsert.0.5.0\lib\OLE-Storage_Lite-0.19\OLE-Storage_Lite-0.19\sample\smpsv.pl
ExcelToMSSqlInsert.0.5.0\lib\OLE-Storage_Lite-0.19\OLE-Storage_Lite-0.19\sample\test.xls
ExcelToMSSqlInsert.0.5.0\lib\OLE-Storage_Lite-0.19\OLE-Storage_Lite-0.19\t\00_load.t
ExcelToMSSqlInsert.0.5.0\lib\OLE-Storage_Lite-0.19\OLE-Storage_Lite-0.19\t\01_date_conversion.t
ExcelToMSSqlInsert.0.5.0\lib\OLE-Storage_Lite-0.19.tar.gz
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\Changes
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\CP932Excel.map
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\Makefile.old
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\Makefile.PL
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\MANIFEST
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\META.yml
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\ParseExcel\Dump.pm
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\ParseExcel\FmtDefault.pm
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\ParseExcel\FmtJapan.pm
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\ParseExcel\FmtJapan2.pm
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\ParseExcel\FmtUnicode.pm
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\ParseExcel\SaveParser.pm
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\ParseExcel\Utility.pm
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\ParseExcel.pm
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\README
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\README_Japan.htm
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\chkFmt.pl
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\chkInfo.pl
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\dmpEx.pl
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\dmpExH.pl
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\dmpExHJ.pl
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\dmpExJ.pl
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\dmpExR.pl
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\dmpExU.pl
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\dmpEx_2xml.pl
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\Excel\AuthorK.xls
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\Excel\AuthorK95.xls
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\Excel\FmtTest.xls
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\Excel\oem.xls
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\Excel\Rich.xls
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\Excel\Test1904.xls
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\Excel\Test1904_95.xls
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\Excel\Test95.xls
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\Excel\Test95J.xls
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\Excel\Test97.xls
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\Excel\Test97J.xls
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\iftest.pl
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\iftestj.pl
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\Ilya.pl
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\README
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\res_fmt
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\res_info
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\res_oem
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\res_rich
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\res_sample
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\res_samplej
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\sample.pl
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\sampleOEM.pl
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\sample_j.pl
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\smpFile.pl
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\sample\xls2csv.pl
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603\test.pl
ExcelToMSSqlInsert.0.5.0\lib\Spreadsheet-ParseExcel-0.2603.tar.gz
ExcelToMSSqlInsert.0.5.0\log\
ExcelToMSSqlInsert.0.5.0\log\
ExcelToMSSqlInsert.0.5.0\Logger.pm
ExcelToMSSqlInsert.0.5.0\output\
ExcelToMSSqlInsert.0.5.0\output\
ExcelToMSSqlInsert.0.5.0\perlminlogger\
ExcelToMSSqlInsert.0.5.0\perlminlogger\
ExcelToMSSqlInsert.0.5.0\sql\
ExcelToMSSqlInsert.0.5.0\sql\
ExcelToMSSqlInsert.0.5.0\SqlInsertTemplate.tmpl.pl
ExcelToMSSqlInsert.0.5.0\tags
ExcelToMSSqlInsert.0.5.0\Timer.pm