I don't know much about MS Access, but I assume it can import CSV files. If this "dumping" is a one-shot deal for the event, could you export the data from MySQL as a CSV file (possibly using Perl), then import that into Access?
FYI, Perl can talk to Access, but I believe it needs the DBD::ODBC module to do so.
Update: Here's a little script that exports a PostgreSQL table of mine to a CSV file. You can adapt this to your MySQL table with only a couple of changes (connection string, user/pass, table name.)
#! /usr/bin/perl
use strict ;
use warnings ;
use DBI ;
use Text::CSV_XS ;
my $dbh = DBI->connect( 'DBI:Pg:dbname=odms', 'doug', '' )
or die "Couldn't connect: $!" ;
my $csv = new Text::CSV_XS ;
my $sth = $dbh->prepare( 'select * from v_doc_list' ) ;
$sth->execute ;
while ( my $ary_ref = $sth->fetchrow_arrayref )
{
$csv->combine( @$ary_ref )
or warn "Error: could not construct CSV string from [@$ary_ref]"
+ ;
print $csv->string, "\n" ;
}
$dbh->disconnect ;
exit ;
_______________
DamnDirtyApe
Those who know that they are profound strive for clarity. Those who
would like to seem profound to the crowd strive for obscurity.
--Friedrich Nietzsche
|