David, There are many issues that must be considered before one can make a generalised statement that the data should be transferred. I am not especially fond of MS Access as a DBMS but it has a reasonable UI and can link to other databases via ODBC. In my situation, I develop test data on an Oracle databases and have many link tables in MS Access. Oracle is the production database for the government agency I work for and I am not about to change that. I have local Access tables that I use for conversion and other data manipulations and it works fine.
I used the DBI::ODBC on Windows to create large amounts of test data by reading my MS Access tables. I also use the DBI::Oracle to extract other sets of test data and reformat for input into a legacy system. I use MS Access with ODBC to link my mySQL tables from another application. I use PHP and mySQL for a website I have developed but a lot of the testing is still done using MS Access and ODBC. I have not used any UNIX ODBC drivers yet. Regards, Dennis -----Original Message----- From: news [mailto:[EMAIL PROTECTED] On Behalf Of David Claughton Sent: Wednesday, 24 March 2004 8:42 PM To: [EMAIL PROTECTED] Subject: Re: ODBC + MSAccess + Perl + Linux or FreeBSD question. I would be inclined to dump MSAccess and transfer the data to an Open-Source database (e.g. MySQL www.mysql.com ) instead. MySQL has a Windows version as well, so you should be able access the DB in both environments, if that is a requirement. Regards, David. "Ricardo Pichler" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi everyone, > I'm try to make this work: perl + unixodbc + > MSAccess but I can't" > > Anybody make this work? Or others ways to read and > write access file with perl in linux or freebsd? > > Thank's in advance! > -- > Ricardo Pichler >
