Importing table with existing Record ID#s
Hello QB Community,
I am creating a new application and I want to preserve the record id # from my original application that is still in use for the ease of keeping data updated. However when i...
Forum Discussion
Thanks Renee, Chayce and Brian,
These are great suggestions and what I am now understanding is that the Record ID must contain not only unique numbers but also in increment sequence.
My issue is that I do have deleted records in that table which were "burned" otherwise I would attempt the blank import. I am really hoping to avoid changing the key field as it has caused issues for me doing so in the past.
Does anyone have a quick way to repopulate the missing records? Seems like a logistical nightmare...
Thanks,
Josh
------------------------------
Joshua Kaye
------------------------------
You can still do the blank import you'll just have to 'burn' the records from the new table. In practice once you backload the data from your old table there should be at least some data that you can easily run a report of records that don't have anything in them and just delete them back out so your tables match exactly.
Since they are deleted from your old table they are now gone for good
------------------------------
Chayce Duncan
------------------------------