comparing data fields
We are using QB as our main database to track our Project management dates. Our client uses another database. We need to have both databases show the same data. We can not do bulk imports into the Cli...
Forum Discussion
Yes, we do have a common number that is used, it is unique to each project. We have to pull the data out of their system as needed. It can be pulled out in CSV or excel format. They will not provide anything except limited access to their system. Seeing that we have to do it, I just import the file into a table in our QB. Either I have to import it into QB or upload it to box and then wait for the sync, so it makes more sense for me to just import it. We use sync on other tables for other data. But I don't see how it would work in this instance. I do not want the data in their system overwriting what is in QB. We need to have our QB data be the source data, but we can't upload into their system. We have to manually enter it field by field, that 's why we need to see just the differences.