MS Excel Tool Column-To-Query

1
MS Excel ToolColumn-To-Query
2
Agenda

• Purpose
• Target User
• Benefits
• System Requirement
• User Guide
• Introduction
• Step 1
• Step 2

3
Purpose
ColumnToQuery tool is designed to quickly convert
the data in column format (spreadsheets) to SQL
or Siebel query format.
4
Target User

• Data Migration Team
• Data Conversion Team
• Application Maintenance Team

5
Benefits

• Two step conversion
• With traditional method, one needs to use
  concatenate function in excel and apply replace
  function to remove unwanted spaces.
• This tool enables user to retrieve the same
  results in just 2 steps. Copy-Paste the data and
  click Convert button.?
• Time savings by 75
• Traditional approach takes more than 60 seconds.
• This tool takes lt15 seconds.
• MS Office Platform
• No installation is required.
• This tool is build on MS Excel. Wide acceptance
  of MS Office tools enable high availability of
  the tool as well.

6
System Requirements

• Windows XP or higher.
• MS Excel 2003 or higher.
• Macros should be enabled in MS Excel.
• Please note that Openoffice Spreadsheet is not
  supported.

7
User Guide - Introduction

• Conversion includes two easy steps
• Copy and Paste data
• Click To SQL Format button or To Siebel
  Format button

8
User Guide Step 1

• Copy and Paste data
• Copy the data to be converted in Column A.

9
User Guide Step 2

• Click To SQL Format or To Siebel Format
  Button
• Click To SQL Format button to convert data to
  SQL format.
• OR click To Siebel Format button to convert it
  to Siebel format.

10
Thank you !