Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Thanked 0 Times in 0 Posts

    Import Specs: Insert new field?

    Is it possible to insert a new field into an existing import specification? Does there exist a way to edit that specification outside of the import window?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Import Specs: Insert new field?

    The import and export specifications are stored in two system tables:
    MSysIMEXSpecs contains the names and general settings.
    MSysIMEXColumns contains the field settings.

    You can create queries (or SQL statements) to manipulate these, but you must be <font color=red>extremely</font color=red> careful - it is easy to mess up your database if you modify the Access system tables. Inserting, deleting or moddifying a record often means that you must modify other records too - something the Wizard takes care of automatically.

    If you want to see what the tables look like, select Tools/Options..., View tab and check System Objects.
    Study the settings for existing specifications in detail before trying to play with them and always backup your database first!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts