If I understand your question correctly (obtain 50 rows via email), have your 'partner' export the 50 rows to a comma or tab delimited text file, zip it and then send it to you.  When you receive it, unzip and bcp in or bulk insert into your table.  Sounds so easy, I'm almost sure I'm missing something..