Could I link my SQL to my database to upload daily?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
My group has a SQL script that we pull from our company's data mart daily. Currently we download daily data into excel format(.xlsx), which we manually import into QB every morning.

But another group went to a QB training in Nov 2015, and said that they heard that we can link our QB to SQL, so that we do not have to go through so many steps just to upload the data every morning.

Does anyone know if this is possible (oh and free, without using another web-platform or program)?

Thank you very much in advance!
Photo of Neve

Neve

  • 260 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
You could potentially figure out a way to get that excel file to a google docs (free) location and then maybe use quickbase sync (also free) to import the data into a quickbase table.

Let me know if that is helpful.
Save it as a .csv to Dropbox and syn with Quickbase