SPUG: txt -> db

[aaron salo]

Dave,

Although they may offend our sensibilities, sometimes these things are 
unavoidable. As a bonus, if you simply MUST get at an Access database 
cross platform (i.e., from a web server on your Linux box to a .mdb on a 
Windows box), here is a good step by step on setting up DBI::Proxy to do 
the trick.

http://www.awilcox.com/geek_stuff/perl/proxy.html

More on point for your situation, if you are wanting info on how to set 
up the ODBC driver to "access" Access using Perl and DBD::ODBC, which 
sounds more in line with what you may be doing, you can skip the 
Proxy-specific steps and simply follow the steps for installing 
materials on the Windows machine, that is a subset of the instructions 
at the link above. Et Voila.

James' suggestion about using the myODBC driver in order to use Access 
as a front end for a mySQL database is also a very handy thing to do, an 
excellent plan if you have the freedom to do this for a longer term 
solution. Your users don't know anything about the back end, they just 
see Access and they are happy.

Good luck,
Aaron