This online tool will make it easy to exchange data between the business and IT.
The business can deliver a list of key numbers 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 (multiple values).
A view options are added for different transformation purposes and types 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!
Put your list here and in return you will get an WHERE IN(multiple values) string for the SQL database query.