import from ms access table name unknown

Discussion in 'Microsoft Access Getting Started' started by mcnews, Mar 6, 2012.

  1. mcnews

    mcnews Guest

    i need to import a table into ms access from ms access. there will only be one table, but i can't rely on the name of the table being the same each time the report is executed.
    how?
    tia,
    mcnewsxp
     
    mcnews, Mar 6, 2012
    #1
    1. Advertisements

  2. On Tue, 6 Mar 2012 07:56:00 -0800 (PST), mcnews <>
    wrote:

    >i need to import a table into ms access from ms access. there will only be one table, but i can't rely on the name of the table being the same each time the report is executed.
    >how?
    >tia,
    >mcnewsxp



    Take a look at the Tabledefs collection in the source database. It will have
    entries for the essential systems tables, all with names starting with MSys; I
    presume you want what's left over.
    --

    John W. Vinson [MVP]
    Microsoft's replacements for these newsgroups:
    http://social.msdn.microsoft.com/Forums/en-US/accessdev/
    http://social.answers.microsoft.com/Forums/en-US/addbuz/
    and see also http://www.utteraccess.com
     
    John W. Vinson, Mar 6, 2012
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Vuunderboy

    Access Queries with Unknown Number of Params

    Vuunderboy, Jul 1, 2003, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    715
    Bullschmidt
    Jul 1, 2003
  2. Kevin
    Replies:
    3
    Views:
    786
    MacDermott
    Sep 9, 2004
  3. Narendra
    Replies:
    1
    Views:
    1,626
    GitarJake
    Mar 1, 2005
  4. Guest

    Access combo box-show name, not ID, in table?

    Guest, Apr 22, 2005, in forum: Microsoft Access Getting Started
    Replies:
    30
    Views:
    2,999
    Fred Boer
    Apr 30, 2005
  5. Replies:
    1
    Views:
    784
    John Vinson
    Apr 18, 2006
  6. Guest

    I want Access to import an Oracle table..

    Guest, May 25, 2006, in forum: Microsoft Access Getting Started
    Replies:
    3
    Views:
    278
    Guest
    Jul 31, 2006
  7. Guest

    Table with unknown number of columns?

    Guest, Jul 25, 2007, in forum: Microsoft Access Getting Started
    Replies:
    4
    Views:
    378
  8. Reggie

    Import file with spaces in file name

    Reggie, Mar 17, 2010, in forum: Microsoft Access Getting Started
    Replies:
    6
    Views:
    1,594
    Reggie
    Mar 18, 2010
Loading...