Appending data into an MS Access table via Perl

[Tript99]

Hello,
Does anyone have an example of some code that will allow me to use Perl to append data in a text file into a table in microsoft access? Is this even possible? I searched through the archives but couldn't really find anything.
Any help would be great!
Thanks,
Tript.

 

[TheGenius22]

Look at module DBI and its documents. All answers you are looking for are in there.

If you need more help, please post some of the code.

 

[icrf]

Specifically, ADO would be a useful driver:

http://search.cpan.org/author/TIMB/DBI-1.19/lib/DBD/ADO.pm

You can connect to Access databases without first creating a data source. I've done things like this in the past:

my $DSN = 'driver=Microsoft Access Driver (*.mdb);dbq=HClub.mdb';
my $dbh = DBI->connect("dbi:ADO:$DSN",{ RaiseError => 1, PrintError => 1, AutoCommit => 0 });

But yeah, first find some documentation/tutorial on DBI itself before diving in too deep. You'll thank yourself later on.

----------------------------------------------------------------------------------
...but I'm just a C man trying to see the light