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

Question

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.

_anomdiebolt_ · Answer

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 · Answer

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

_anomdiebolt_ · Answer

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.

Forum Discussion

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

Related Content

Merge Imports

Pipeline to add Parent record from child import

Custom Record Titles

Using Grid Edit to Edit Multiple Records at Once

Record Details