Discussions

Expand all | Collapse all

Import data into Quickbase table via SQL Query

  • 1.  Import data into Quickbase table via SQL Query

    Posted 08-20-2018 17:35
    How to Import data into Quickbase table via SQL Query, currently i am using Oracle database


  • 2.  RE: Import data into Quickbase table via SQL Query

    Posted 08-20-2018 19:03
    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


  • 3.  RE: Import data into Quickbase table via SQL Query

    Posted 08-20-2018 20:53
    Thanks Braller, so is it free the qunect?


  • 4.  RE: Import data into Quickbase table via SQL Query

    Posted 08-20-2018 20:47
    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.


  • 5.  RE: Import data into Quickbase table via SQL Query

    Posted 08-20-2018 21:49
    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.