www.webdeveloper.com
Results 1 to 2 of 2

Thread: Help writing a perl script

  1. #1
    Join Date
    Jan 2006
    Posts
    96

    Help writing a perl script

    Hi,
    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.

    For Example:
    Excel Data
    Col1
    1234566
    1234666
    1234766
    .
    .
    .Up to 30,000 rows
    9999999

    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

    --Thanks

  2. #2
    Join Date
    Jan 2003
    Location
    USA
    Posts
    687
    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles