SPUG: txt -> db
aaron salo
aaron at activox.com
Wed May 12 10:17:21 CDT 2004
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
More information about the spug-list
mailing list