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 ;
[download]

_______________
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