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

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
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.
Photo of David Brogdon

David Brogdon

  • 1,222 Points 1k badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,074 Points 20k badge 2x thumb
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.
(Edited)
Photo of David Brogdon

David Brogdon

  • 1,222 Points 1k badge 2x thumb
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

Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,074 Points 20k badge 2x thumb
When importing records into a table if the [Record ID#] is in the CSV data then that record will be updated in the target table.