Forum Discussion

MehdiMaskoot's avatar
MehdiMaskoot
Qrew Trainee
7 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
7 years ago
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
7 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.