Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Export Text Specs (2k,XP)

    I have run across a few challenges in exporting data into a fixed width text file. I can create the exported file with no problem. However, I would like to move the export spec to a different database.

    I found two tables (MSysIMEXSpecs and MSysIMEXColumns) that contain the information. Is it ok to copy those tables nto another database? Or should I append them? Are there other files or other steps I should take to ensure that I don't mess up the specs and don't negatively affect the database I am putting these into?

    thanks in advance your ideas!

    Ken

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Export Text Specs (2k,XP)

    MSysIMEXSpecs and MSysIMEXColumns are system tables maintained by Access itself. Although you can copy them to another database, the copies will be renamed to MSysIMEXSpecs1 and MSysIMEXColumns1 or something like that, and they won't be used by the destination database. It is not possible to edit or append records in the system tables.

    You can import the import/export specifications from another database:
    - Select File | Get External Data | Import...
    - Locate and select the database whose specifications you want to import.
    - Click Import.
    - In the Import Objects dialog, click Options >>
    - Clear the "Relationships" check box.
    - Tick the "Import/Export Specs" check box.
    - Click OK.

  3. #3
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Export Text Specs (2k,XP)

    WOW! As usual I was making it more difficult than necessary.

    THANKS!

Posting Permissions

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