Skip to main content
Question

Is it possible to bulk import records into a new table and have them match record ID's ?

  • October 16, 2018
  • 0 replies
  • 67 views
I need to import a set of records from an old table into a new table, but I need the Record ID's to stay the same because they are used as a unique identifier in the product #

The problem is that there are gaps in the old record ID's so I cant just direct import and match ID's. For example, I have records # 138, 139, 141,143, 144, etc. 

Any help is appreciated.
    This topic has been closed for replies.

    • anomDiebolt
    • Registered
    • October 16, 2018
    In the new table create a set of n records where n is the maximum [Record ID#] in the old table. These n records should be empty - no fields values specified. Now import the records from the old table into the new table. Finally delete the records in the new table that are empty (ie nothing was imported from the old table).

    Depending on your comfort level with this procedure you may use a variety of tricks in Excel to generate a set of sequential [Records ID#] values or temporary fields to help identify fields that have not be updated by the import.

    With this procedure the new table will hold the same information as the old table including [Record ID#] values.
    • DavidBrogdon
    • Author
    • Registered
    • October 16, 2018
    Thanks for your reply. I understand the first paragraph, but not entirely the second. What do you mean by "fields that have not been updated by the import" ? Can you maybe give an example? Thanks

    Terms & ConditionsAccessibility statement