Utility Tool – Column To Query


Hi All,

Please have a look at new utility – ColumnToSQL.

It is used to convert data from MS Excel columns to below formats:

  • SQL Query. For example – select * from S_org_ext where row_id IN (‘a’,’b’,’c’,’d’……)
  • Siebel Query. For example – In Last Name column, you may query as “= ‘a’ Or =’b’ OR =’c’ OR …….”


Origin Of The Tool

In data migration phase, while loading data for various entities we had fallout records (i.e. Records that failed to load successfully). We needed to re-extract these records. These count of fallout records was generally in hunderds and it used to take huge amount of time to put those Records Ids in the below shown format. Thus I designed ColumnToQuery macro tool.


Presentation and User Guide

For detailed insight and user guide, please download Powerpoint presentation here >> ColumnToQuery – Presentation


Tool Setup

Please download the setup of ColumnToQuery tool here >> ColumnToQuery – Setup


Appreciate your feedback

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: