Publisher review:Format database field names in Excel script applies some simple formatting rules to the first row and addresses duplicate names. This script opens the file in Excel, and applies some simple formatting rules to the first row and addresses duplicate names. Then when the file is imported on an SQL Server , the column names are somewhat usable.
Format database field names in Excel 1.1 is a Python script for Database Tools scripts design by Matt Keranen.
It runs on following operating system: Windows / Linux / Mac OS / BSD / Solaris.
applies some simple formatting rules to the first row and addresses duplicate names.
Operating system:Windows / Linux / Mac OS / BSD / Solaris