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]

Reply via email to