Forum Discussion

MehdiMaskoot's avatar
MehdiMaskoot
Qrew Trainee
6 years ago

I need Import to do only inserting without updating existing records

Hi everyone, I have a table that I want to import my spread sheet data into it, without updating my existing records. I don't have Record ID as my Primary key. My table has its own PK. When I try to i...
Data import and export
SuryaExpert's avatar
SuryaExpert
Qrew Assistant Captain
As long as you have the primary key field in the xl that you are importing from, quickbase will only insert/update. If you want to only insert, I would consider removing that column from the XL.
MehdiMaskoot's avatar
MehdiMaskoot
Qrew Trainee
6 years ago
Remove the PK from my XL??? :)))
How does QB know the value of my PK field then???
I am receiving the XL from a customer and it has thousands of records that I don't know what records are new. I guess QB needs to redesign its import then.