Skip to main content
Question

QuickBase to Sharepoint Sync?

  • November 5, 2019
  • 0 replies
  • 195 views
So I have a lot of Data I like to keep track of in QuickBase. I have several dozen customized reports I check daily and weekly.

Some of this data contains percentage scores for coworkers, averages, etc..

I used to use Google Suite to track this information, but now we are using Microsoft Office 365 and Sharepoint.

So I've been trying to find a way to export this data live from QuickBase into Excel in Office 365. Our spreadsheets where we track and update information is in Excel on SharePoint.

I've tried using the desktop version of Office 365's Excel and go into the Data and Get Data From Web and other options. I've went into the refresh options to try to refresh hourly. It won't.

Is it not possible to sync them so the information in QuickBase exports and updates the data in sharepoint?

I can save the data in Quickbase as a Spreadsheet CSV file and load it into Excel just fine, but it won't refresh and update.

------------------------------
Joey Fletcher
------------------------------
This topic has been closed for replies.

  • ProjectsForce1
  • Quickbase Alumni
  • November 5, 2019
Have you tried Zapier? I know they have a Microsoft Excel resource as well as an upcoming Sharepoint.​

------------------------------
ProjectsForce
------------------------------
Forum|alt.badge.img+4
  • JessicaFeauto
  • Quickbase Alumni
  • November 5, 2019
Try QuNect ODBC.  This will allow you to connect it to a database application such as Access or Excel.  The cost is around $200 per year and I've never had limits on data.  You might need to know a little SQL to pull the data and schedule a batch file to pull it, but it can be done without too much effort.

I think they'll give you a free month trial to test it out.  Let me know if you need more info.

------------------------------
Jessica Feauto
------------------------------
Forum|alt.badge.img+15
  • DonLarson
  • Quickbase Alumni
  • November 6, 2019
Joey,

We built Paasporter, www.paasporter.com to Extract Quick Base data, index and create a new SQL Compliant DB.  Now you have a data source that traditional software development tools can connect with.   Not only Sharepoint but any other archiving, complex calculations or BI/BA needs can take advantage of it.

Please reach out for a demo.

Don

------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Terms & ConditionsAccessibility statement