Converting text file to access

[PJYelton]

Hi all, relatively new to perl and had a quick question. Using a few modules I've been able to easily create and parse excel files. Now my question is, can someone point me to a module that allows me to convert a text file to an access database? I've tried to search for something but to no avail.

Thanks!

 

[Rieekan]

Take a look at the DBI and specifically DBD::ODBC modules. These modules allow you to read and write from any ODBC database connection. All you need to know is a little SQL for the database you're accessing and perl.

It won't write the data structures for you of course, as databases are generally relational and need some up front work by the developer to be set up, but it will do the trick.

- George