Export table from old Access 2002 Database to create a new database

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • learning_codes@hotmail.com

    #1

    Export table from old Access 2002 Database to create a new database

    Hi ,

    I'm wondering if there is a way for me to export some tables including
    data and structure from old database to a new database and then save as
    new database name.

    I try to create a marco and it create a new table within the same
    database.

    I would be appreciated if you can help me to create a code for one
    button that will export selected tables to a new database and then save
    as a new database name file.

    Thanks ;-)

  • Allen Browne

    #2
    Re: Export table from old Access 2002 Database to create a new database

    There's some example code here:


    It creates a new database, and loops through the tables in the current
    database, writing them to the new database. If a table is skipped (e.g.
    currently locked), it writes that to an error log.

    It exports the data into the backup file, whether the tables are linked or
    local. It does not create relations, or set all the field properties.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    <learning_codes @hotmail.comwro te in message
    news:1157413122 .083228.93930@b 28g2000cwb.goog legroups.com...
    >
    I'm wondering if there is a way for me to export some tables including
    data and structure from old database to a new database and then save as
    new database name.
    >
    I try to create a marco and it create a new table within the same
    database.
    >
    I would be appreciated if you can help me to create a code for one
    button that will export selected tables to a new database and then save
    as a new database name file.
    >
    Thanks ;-)

    Comment

    Working...