Clarification on: Can I talk to an MS Access DB using Perl?

Sam_Lewy has asked for the wisdom of the Perl Monks concerning the following question:

In Can I talk to an MS Access DB using Perl? the question was asked, “Can I talk to an MS Access DB using Perl“. Please could you clarify, are all the suggestion there just for a Perl running on Windows or can I use any of these ideas on a Unix server which is mapped/mounted/connected (sorry, not sure of the right term) to a Windows machine which has my MS Access DB running?

janitored by ybiC: Converted <a href...> link to PM style [id://...] to avoid logging out monks with cookie from different domain. Eg: (with(out) leading "www")

Comment on Clarification on: Can I talk to an MS Access DB using Perl? Download Code

Replies are listed 'Best First'.
Re: Clarification on: Can I talk to an MS Access DB using Perl? by BaldPenguin (Friar) on Jul 12, 2005 at 22:22 UTC
The suggestions involving Win32::ODBC or ActiveState require you be running windows. The DBD::ODBC instructions can work if you have UnixODBC installed. Don WHITEPAGES.COM \| INC Everything I've learned in life can be summed up in a small perl script!	[reply]
Re: Clarification on: Can I talk to an MS Access DB using Perl? by marto (Cardinal) on Jul 12, 2005 at 22:22 UTC
Hi, To avoid confusion, you could have Stated the operating system in the question/question title :D Regrdless, using DBD::ODBC in conjunction with MDB tools should be a place to start looing. MDB tools: provides "A sparse but functional ODBC driver is included as well" as stacks of other stuff. However, (shameless 'I hate MS Access use MySQL if you can' rant) if moving from MS Access to MySql is an option, you may want to have a look at this node "Re: Converting Microsoft Access to Perl/Tk/DBI" where I detail a tool developed for (almost) painless migration from Access to MySQL. Hope this helps. Martin	[reply]