In general, you should use the DBI interface. To read data
from a CSV file, use DBD::CSV, and to write to an Access Database
you could either use DBD::ODBC or DBD::ADO.
Look in the documentation of the mentioned modules for more info.
Jouke Visser, Perl 'Adept'
| [reply] |
To read a CSV file there are basically three options. In
increasing order of complexity.
- Use the quotewords function from the standard
Text::ParseWords module
- Install the Text:CSV_XS module from CPAN
- Install the DBD:CSV module from CPAN and use a full
DBI interface to the file
--
<http://www.dave.org.uk>
"Perl makes the fun jobs fun
and the boring jobs bearable" - me
| [reply] |
You missed my favourite: DBD::RAM, which consolidates
DBD::CSV and other similar modules, making it easier to
read CSV, XML, etc... and to convert between the various
formats.
| [reply] |