Create an MS Access file using DBI

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • hanz
    New Member
    • Jul 2008
    • 2
    #1

    Create an MS Access file using DBI

    Hello everyone,

    I am trying to create an MS Access file using Perl in a Linux environment. By the way I am on a SuSE Linux envrironment. I have already installed the DBI module. I am looking for some direction on how to go about accomplishing my task. Thanks in advance,

    Hanz
    Tags: None
    • eWish
      Recognized Expert Contributor
      • Jul 2007
      • 973
      #2
      Welcome to Bytes.com!!!

      Can you give more details. That is a very vague description. Do you have any sample code that we can look at?

      --Kevin

        Comment

        • hanz
          New Member
          • Jul 2008
          • 2
          #3
          Originally posted by eWish
          Welcome to Bytes.com!!!

          Can you give more details. That is a very vague description. Do you have any sample code that we can look at?

          --Kevin
          thanks Kevin!

          I have not written any code for this project yet since I am still trying to gather enough info to tackle the problem. What I want to do is output the data I show in my webpage to a MS Access file at the user request, so they can download the file to their PC. I have done this with MS Excel since Perl has the package Spreadsheet::Wr iteExcel. My website is set up on a SuSE Linux and I have access to an Windows machine on my network if I have to install Access there.
          Any help or direction you can me give is appreciated.

            Comment

            • numberwhun
              Recognized Expert Moderator Specialist
              • May 2007
              • 3467
              #4
              Originally posted by hanz
              thanks Kevin!

              I have not written any code for this project yet since I am still trying to gather enough info to tackle the problem. What I want to do is output the data I show in my webpage to a MS Access file at the user request, so they can download the file to their PC. I have done this with MS Excel since Perl has the package Spreadsheet::Wr iteExcel. My website is set up on a SuSE Linux and I have access to an Windows machine on my network if I have to install Access there.
              Any help or direction you can me give is appreciated.
              Well, my first suggestion is that you have a look at the DBI page on CPAN. That will show you how to use the DBI module. Using that, you can issue the necessary commands to not only populate the database, but create it as well if needed.

              Hope that is what you are looking for. As Kevin said, still a little vague.

              Regards,

              Jeff

                Comment

                Previous template Next
                Working...