I want to write a perl script or any other script which will do following:
I have around 30,000 numiric values in my excel column. For these valuses i need to write a script which will read
values from the column and append them to an sql IN(Clause) 200 max in one IN.
.Up to 30,000 rows
SQL: select ColVal1, ColVal2 from tablename where id in(1234566,1234666) [200 Max].
after i run the sql the results i need to send to Excel.
I ahve no idea how i can do it some one please help
I can refer you to an alpha version of DBD::Excel. Sounds as if that module (along with supportive modules - Spreadsheet::ParseExcel, Spreadsheet::WriteExcel, SQL::Statement and DBI - ) may do the trick. Do read the documentation or search deeper at cpan.