This online tool will make it easy to exchange data between the business and IT.
The business kan deliver al list of key number from an Excel sheet as an IN string to be used in a SQL query in the database.

SELECT * FROM TABLE WHERE CODE_ID IN (list).

A view optoins are added for different transformation purposes and other kind of data.

  • No table data insert needed in production databases
  • No ODBC connection with database needed
  • No Excel scripting macro functions needed
  • Just email your key list and get corresponding data back from IT
  • Leading zeros that drop off in Excel can be restored
Enjoy!

Put your list here and in return you will get an IN() string for the SQL database query.
 With quotes for VARCHAR  
 Remove the dots from the numbers  
 Left padding with 0   to # positions



Need more options? Please let us know! info@paros.nl