Hello,I haven't done this myself, but one of my friends uses a perl thing call DBI::Proxy. You install it on the server ( ie machine with MS Access ) and client ( ie machine you'll be running the Perl scripts from ) and it *somehow* works.
This is partially off-topic as I am looking at reading Access tables from either Perl (preferred) or MySQL, but if anyone has any suggestions, I will be most grateful.
My first thoughts were to write a Perl script which will read 2 columns
from an MS Access table and load them into MySQL. It would be run at a
click of a button from a web interface to display updated MySQL tables.
However, after few hours of "googling" it appears that this is easier said than done due to ODBC and DSN quirks. Direct import into MySQL requires external utility like DBTools which defeats desired automation of the procedure. Is there a "known" best way to do this and has anyone done something similar?
Thanks in advance for any hints.
Sorry I'm a bit lean on the details. I've seen it working. Google for it.
Dan
-- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]