Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2005
    Posts
    2

    Red face Unanswered: Importing from an old DB into a new DB

    I have an old database which contains two field that I would like to combine into one field in the new database. Can I do this in one import? If so, how? If not, can I do this with two separate imports? I have tried to do two separate imports but when I do the second, the information form the first is lost.

    Thanks

  2. #2
    Join Date
    Feb 2005
    Posts
    1
    To import data for once from two fields at once, it is possible to create a calculated field in which to collect data from two fields in old base. And to import to new base data from this calculated field.

  3. #3
    Join Date
    Feb 2005
    Posts
    2
    Could you please tell me how and what the calcuation is

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Or create an update query with the recordsource as the otld table, the destination table the new table. To make life easier you could even create the new column in the existing table, then create the update query to update that column with the desired values

    create a new query
    in the query types / options specify an aupdate query

Posting Permissions

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