Translating data from MS Access to MS Excel

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • muralin
    New Member
    • Jul 2007
    • 1

    Translating data from MS Access to MS Excel

    Please tell me how can I get the data from MS Access using perl script and that data I need to export into excel automatically using perl. Please post some sample code.
    Thanks In Advance!
  • miller
    Recognized Expert Top Contributor
    • Oct 2006
    • 1086

    #2
    You have posted your question under Perl Articles instead of the Perl Forum.
    I have moved it across for you.

    - MODERATOR

    Comment

    • numberwhun
      Recognized Expert Moderator Specialist
      • May 2007
      • 3467

      #3
      Originally posted by muralin
      Please tell me how can I get the data from MS Access using perl script and that data I need to export into excel automatically using perl.
      Well, to start with, to access the Access database, you will probably want to use the DBI module. You can find information on this either at this website or at CPAN. To access and write to an Excel file, you will possibly want to use the Win32::Ole module from CPAN. Those should get you started.

      Originally posted by muralin
      Please post some sample code.
      Since this is forum and not a code writing service, why don't you write the code and we will help you as you go(where we can).

      Regards,

      Jeff

      Comment

      Working...