Discussions

Expand all | Collapse all

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

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

    Posted 10-16-2018 15:28
    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.


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

    Top
    Contributor
    Posted 10-16-2018 15:46
    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.


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

    Posted 10-16-2018 16:18
    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



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

    Top
    Contributor
    Posted 10-16-2018 16:37
    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.