Quick Base Discussions

Expand all | Collapse all

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

  • 1.  Could I link my SQL to my database to upload daily?

    Posted 03-06-2017 22:26
    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!


  • 2.  RE: Could I link my SQL to my database to upload daily?

    Bronze
    Contributor
    Posted 03-07-2017 05:48
    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.


  • 3.  RE: Could I link my SQL to my database to upload daily?

    Posted 03-07-2017 06:43
    Save it as a .csv to Dropbox and syn with Quickbase