exceltomssqlinsert

TSQL inserts generator and runner using Excel as input

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

Project Information

The project was created on Apr 23, 2011.

Labels:
Agile Windows Excel Perl