Dan Muey wrote:
> Hello faithful list!
>
> Has anyone worked with Microsoft Access Databases with perl?
>
> I either need to run a query on a remote Access Database or
> Have the people that have that database save it in CSV format
> or something to import it into mysql.
>
> Any ideas how best to
> Would UnixODBC-0.19 be of any use?
>
> http://unixodbc-pm.org/
Perhaps but not with these folks.
I'll take a gander at that thoguth for future reference.
Thanks
Dan
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
On Wed, Jun 18, 2003 at 09:20:55AM -0500, Dan Muey wrote:
>
> > > Any ideas how best to deal with Access Databases with perl?
> >
> > Look up "MDB Tools" on Freshmeat.net
> Thanks!
>
> --
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
Would U
> Here's how I used to connect using DBI and DBD::ODBC. I
> would pass the access database's name as a parameter. From
> here you can just use dbi and SQL to manipulate the DB. If
> you need more help with DBI I would recommend posting in the
> dbi-users group.
>
> my $dbh = DBI->connect("d
> > Any ideas how best to deal with Access Databases with perl?
>
> Look up "MDB Tools" on Freshmeat.net
Thanks!
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
> Ick. Don't go there. Bad combination. If you are using Perl,
> try working with mySql or PostgresSql - both have some
> support in Perl. Access complicates things all across the
> board, and it has major scalability problems for any web related work.
You're preaching to the choir my friend. T
ot;dbi:ODBC:driver=Microsoft Access Driver
(*.mdb);dbq=$ARGV[0]", '','') || die "$DBI::errstr\n";
-Original Message-
From: Josh Berkus [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 5:45 PM
To: Dan Muey; [EMAIL PROTECTED]
Subject: Re: Access
Dan,
> Has anyone worked with Microsoft Access Databases with perl?
>
> I either need to run a query on a remote Access Database or
> Have the people that have that database save it in CSV format
> or something to import it into mysql.
>
> Any ideas how best to deal with Access Databases with p
