Access 2003 import specifications

Posted on 2011-10-12
Last Modified: 2012-06-27
How can I view and then copy import specifications to another Access 2003 database?
Question by:dpawlaczyk
    LVL 12

    Accepted Solution

    The import specifications are saved in two system tables in Access these are MsysIMEXColumns and MsysIMEXSpecs.

    You can transfer import / export specifications from database to database using the Options button on the File->Get External Data->Import window.

    Hope this helps,
    LVL 119

    Expert Comment

    by:Rey Obrero
    to be exact

    File > get external data > import
    select the db to import from

    in the import objects window,  click on Options and check Import / export specs

    Author Closing Comment

    Thanks! Exactly what I was looking for! You are the Master!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now