Select based on primary keys in CSV file...

I have a comma separated file of id numbers for which I would like to select more information from a SQL server database.

In my research around the web I learned of the BULK INSERT command to insert data from a csv into the database but I am looking for something of potentially similar functionality but rather instead of inserting I would like to SELECT item description, price, etc FROM the products table for a specified list of a few thousand item ids.

Any suggestions are greatly appreciated. cheers