CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
Search Posts SEARCH
Who's Online WHO'S
Log in LOG

Home: Perl Programming Help: DBI:
Create an MS Access file using DBI


New User

Jul 25, 2008, 5:50 AM

Post #1 of 2 (6486 views)
Create an MS Access file using DBI Can't Post


I am trying to create an MS Access file using the perl DBI but I am not sure how to start. I use SuSE Linux and I have the DBI module installed. Can someone help?


(This post was edited by Hanz on Jul 25, 2008, 6:49 AM)


Feb 27, 2009, 1:14 PM

Post #2 of 2 (5544 views)
Re: [Hanz] Create an MS Access file using DBI [In reply to] Can't Post

Hi Hanz,

I have never done this. So, take my advice for what it's worth. Nevertheless, from my reading, I believe it is possible to do what you want; however, you won't be able to go directly DBI to access UNLESS you move your perl client over to a windows box: Access doesn't run on Linux. Otherwise, you'll have to go through ODBC to get remote access to Access.

For the Linux side, you'll need: Perl, DBI and DBD::ODBC

For the Windows side, you'll need an MS Access odbc driver. I Googled around and it seems like they are out there, esp. for windows server.

Then, you need to configure odbc on your access server.

Once that's done, DBI from your linux client as usual.

Sounds like a royal pain. Unless you absolutely need the ability to update a live copy of the Access db, why not just dump it to a csv file and loading it into your favorite db on linux?

Good luck,


Good luck,



Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives