Forum Discussion

slloydavantsllo's avatar
slloydavantsllo
Qrew Trainee
6 years ago

Anybody have any ideas on how to import data into a synced table?

We are bringing basic info from one app into this one, but we have additional detail workflow that we need to import into the synced table.  It appears that both import/export and pasting into a grid edit report do not work.  Any ideas?
  • DavidJung's avatar
    DavidJung
    Qrew Assistant Captain
    I've created a spreadsheet with the new additional data (with the key field), then saved as a CSV and dumped in my Google Drive sync folder. QB will grab all csv files for importing. This assumes you're sync settings are for 'add and update'. Does this help?
  • I don't think so--this is a QB to QB sync.  You can't change the sync type, right?
  • QB to QB Sync means that the source of truth is the original Sync source QB table.  So the only place to add record is at the source.