Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2002
    Location
    TX
    Posts
    34

    Question Unanswered: import from .mde to .mdb

    I'm having trouble importing! I can import from a .mdb to a .mdb and export from a .mdb to a .mde, however my problem is....

    The raw data is in the .mde that the users have been using. There was a problem with one of the queries in the .mde. Fixed the query with the original .mdb and want to import all the raw data into the .mdb from the .mde so I can save the new .mdb as a .mde, but so that they don't loose any raw data.

    Does anyone know how to import from a .mde to a .mdb?

  2. #2
    Join Date
    Oct 2001
    Location
    Bay Area, CA
    Posts
    117
    same as mdb to mdb, open the mdb, file, import data, etc.
    otherwise....drag and drop
    otherwise....link data, the use query to move data to a table


    hope this helps....

  3. #3
    Join Date
    Apr 2002
    Location
    TX
    Posts
    34
    Torgue, right, I tried that. But it wouldn't import any of the records added prior to me compiling to .mde. For example:

    Original .mdb has 20 records
    Original .mdb is compiled
    New .mde has 20 records
    20 more records are added to .mde
    Query changed in original .mdb
    I want to import the now 40 records in .mde into .mdb
    recompile .mdb to .mde so that new query is in active.

    There are also some new reports, but I have the original .mdb, I just can't seem to get the new records in the .mde into the .mdb

  4. #4
    Join Date
    Feb 2002
    Posts
    403
    Did you try link data, the use query to move data to a table

Posting Permissions

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