Gladly, let me rephrase this as following:
Can an end user be able to paste an excel column containing list of values in a DB table(without affecting other users) or temp table field and
Can this feed as 'criteria' or JOIN to an existing table in SQL query command for searching results?
2 pages are typically involved:
Page 1-The data column (eg. from excel) will be pasted. click "search" button
Page 2-runs SQL query and the results will be displayed
eg. Prod Name (client pastes column)
Apples
Grapes
Bananas
Query Results
Apples $5
Grapes $10
Bananas $3
I am unsure if Multi-lined text box which can hold many values be a right choice and how can a SQL command accept multiple number of rows from it as criteria.