Skip to main content
Question

Import data into Quickbase table via SQL Query

  • August 20, 2018
  • 0 replies
  • 167 views

How to Import data into Quickbase table via SQL Query, currently i am using Oracle database
This topic has been closed for replies.

  • Registered
  • August 20, 2018
https://qunect.com/  I haven't tried that application but it connects quickbase to sql server using ODBC and has been available for years. Worth testing. You can also write your own application that connects to QuickBase using the API which will give you fine grained control but is a bit of work. 
There's also a zap at zapier that may be worth exploring:  https://zapier.com/apps/quickbase/integrations/sql-server

  • Registered
  • August 21, 2018
Sneha,  I have been using the QuNect for SQL Server product since 2013.  I did just upgrade to where i am now Importing and Updating information!  It has been wonderful.  I'm self-taught in SQL so i'm sure the ODBC driver could do waaaay more than my skill level allows!  LOL  It's worth the investment in my opinion.  Good luck in what you decide.

Forum|alt.badge.img+5
  • Registered
  • August 21, 2018
qunect is basically an ODBC driver for quickbase.  We use it extensively to move data back and forth from a MSSQL server.  He has a lot of good documentation on his website, and I would encourage you  to check it out.