Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: exporting MS ACCESS tables into a CSV file

by davidrw (Prior)
on Jul 11, 2005 at 19:52 UTC ( #474073=note: print w/ replies, xml ) Need Help??


in reply to exporting MS ACCESS tables into a CSV file

DBI/DBD are well worth learning and this sounds like a good task to learn on... As for other methods, you could manually export in access, or write a vbscript thing to do it or maybe use Win32::OLE to control access to do it.

here's a snippet that shows how i set up a Class::DBI connection (you can use the same connection string for DBI):

our $dbopts = { AutoCommit=>0, LongTruncOk => 1, LongReadLen => 255 }; our $dsn = GBPVR::CDBI::mdb2dsn('C:\foo.mdb'); MyPackage::CDBI->set_db('Main', "dbi:ODBC:$dsn", '', '', $dbopts ); sub mdb2dsn { my $mdb = shift; return 'driver=Microsoft Access Driver +(*.mdb);dbq=' . $mdb; } 1;

DBI example (see the Tutorials as well):
use DBI; my $dbh = DBI->connect($dsn,$user,$pass,{ShowErrorStatement=>1,RaiseEr +ror => 1, AutoCommit=>0}); my $aref = $dbh->selectall_arrayref("select * from $table",{Slice=>{}} +); # gives ref to AoH


Comment on Re: exporting MS ACCESS tables into a CSV file
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://474073]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (5)
As of 2015-07-05 13:51 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (67 votes), past polls