Format database field names in Excel

Category: Python - Database Tools

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. Date: 10 May, 2012


Format Database - Format Field Names - Database Tool - Format - Field - Names

Homepage: http://code.activestate.com

Developer: code.activestate.com

License: Freeware

Operating System: Windows, Linux, Mac OS, BSD, Solaris

Add a Comment

all are required fields

     
What do you think of this resource?

Select Your Rate:

Votes:0

 

Related Scripts Download

Download Trakker masks the true address of a URL.

developer Developer: scriptsforyou.net
license License: Freeware
operating systems Operating System: All


Dataman is a fully multi-threaded database server and client API libraries in C, C , Java, and a PHP module has now been added as well.

developer Developer: SourceForge.net
license License: Freeware
operating systems Operating System: All


DBReplicator is a powerful open-source java application for network-based multi-master heterogeneous database replication or filtered synchronization.

developer Developer: SourceForge.net
license License: Freeware
operating systems Operating System: All


MyUserAdmin is a user-managing tool for the MySQL database server.

developer Developer: white-space.info
license License: Freeware
operating systems Operating System: All


Timeout errors when backing up and restoring large SQL-dumps.

developer Developer: SourceForge.net
license License: Freeware
operating systems Operating System: All


This script is used to dump simple MySQL tables to a string (and then you can save it in a file if you want, or let user download it).

developer Developer: CubeScripts.com
license License: Freeware
operating systems Operating System: All


PHP common DB interface is a database programming API.

developer Developer: SourceForge.net
license License: Freeware
operating systems Operating System: All


Mapping arbitrary objects to a PostgreSQL database script allows you to introduce arbitrary objects into a PostgreSQL database.

developer Developer: code.activestate.com
license License: Freeware
operating systems Operating System: Windows, Linux, Mac OS, BSD, Solaris


This script shows you a function that creates a cross-tab or pivot table from a normalised input table.

developer Developer: code.activestate.com
license License: Freeware
operating systems Operating System: Windows, Linux, Mac OS, BSD, Solaris