Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much

Re: Parsing/manipulating CSV files

by tospo (Hermit)
on Oct 20, 2011 at 22:39 UTC ( #932773=note: print w/replies, xml ) Need Help??

in reply to Parsing/manipulating CSV files

If you are handling the CSV files in Perl, you might also want to do the database interaction with your Perl scripts to keep it all together. It is possible to query/manipulate an MSAccess database from Perl using the DBI module. See DBD::ODBC

Replies are listed 'Best First'.
Re^2: Parsing/manipulating CSV files
by Anonymous Monk on Oct 21, 2011 at 11:00 UTC

    In this particular instance, I'm looking to get rid of any reliance on MsAccess. It's purely accidental that I use Access now; it just happened that I could write the app within Access as a module as it was available at work so I could use their time to write it (and leave more time for beer at home).

    Database connectivity isn't a requirement for this, I want it to stand alone though I can see that it could be useful for future projects.

      If your data collection is large (for any value of large), DBD::CSV might grow (very) slow. For relatively small dtasets, DBD::CSV gives you instant relief: combining CSV files and selecting from one based on contents of others gets dead easy. When the dataset grows, and you still do not need a full relational dtabase like PostgreSQL or MariaDB, DBD::SQLite might be the interface of choice.

      Enjoy, Have FUN! H.Merijn

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://932773]
and not a whimper to be heard...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (4)
As of 2018-02-19 22:24 GMT
Find Nodes?
    Voting Booth?
    When it is dark outside I am happiest to see ...

    Results (266 votes). Check out past polls.