This is a fairly easy task if you are on win32. Use Win32 OLE to access it like so

sub getTableDefs
{
        $accessConst = Win32::OLE::Const->Load('Microsoft Access 8.0 O
+bject Library');
    $daoConst    = Win32::OLE::Const->Load('Microsoft DAO 3.51 Object 
+Library');

    #array to hold table names
    my @names;

    #Create a new OLE Access.Application object
    my $app = Win32::OLE->new('Access.Application');
    
    #Open the database being worked in
    $app->OpenCurrentDatabase($datasource);
        
    #Get the database object
    my $database = $app->CurrentDb();
    
    
    #Save every table name that is not a system or linked table
    foreach my $i (0..($database->TableDefs->{Count}-1))
    {
        #If the attributes are 0 (ie a normal table)
        if(!$database->TableDefs($i)->{Attributes} || $database->Table
+Defs($i)->{Attributes} eq $daoConst->{'dbAttachedTable'})
        {
            #add it to the list of valid selections
            push @names  $database->TableDefs($i)->{Name};
            
        }
    }
    
    #Quit the application
    $app->DoCmd->Quit($accessConst->{'acQuitSaveNone'});

    #Return the list of valid table names
    return @names;
}

[download]

This is some code I wrote a while ago. It does work but it might not be exactly what you want. It only counts non system tables and non-linked tables. this was in a package.. I moved the constant object declaration into the sub for clarity when I pasted it here.

Again.. this code has been tested and does work. I hope this can be of some use to you.

P.S. If you open up the object browser in access, and you can check what the possible values of the attribute method are, so you can know which table you want to count. There is also a QueryDef collection if you are interested in counting those.

Grygonos

In reply to Re: Flattening Access DB to XML by Grygonos
in thread Flattening Access DB to XML by inman

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.