RE: Reading MS Access tables from MySQL or Perl
Are you looking for an interface to read MS Access other than the default application and MS Query? -Original Message- From: Nik Belajcic To: [EMAIL PROTECTED] Sent: 5/3/04 9:52 PM Subject: Reading MS Access tables from MySQL or Perl Hello, 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. -- Nik Belajcic [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Reading MS Access tables from MySQL or Perl
Nik Belajcic wrote: Hello, 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. 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. 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]
Re: Reading MS Access tables from MySQL or Perl
Thanks for that tip. It helped me find a page which explains it properly. In case anyone else might be interested, here is the link. http://www.awilcox.com/geek_stuff/perl/proxy.html -- Nik Belajcic [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]