How do I import an SQL Management Table onto QuickBase because QuickBase doesn't support ".sql" files, so what is a way around it?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I'm actually an intern here at my company and don't have and QB background but i need to load SQL Tables into this application and also export them ass well.. I'm struggling to do so, can someone help me figure that out? Thanks!
Photo of Andrew

Andrew

  • 0 Points

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,006 Points 50k badge 2x thumb
I'm no SQL expert, but if you coax them into CSV format, then you can import them to a table in QuickBase.
Photo of dwhawe

dwhawe, Champion

  • 662 Points 500 badge 2x thumb
In the SQL Management Studio, under Tools > Query Results > SQL Server there is a Results to Grid choice where you would check include headers in copy then under Results to Text in the upper right choose Comma Delimited.  After doing so, open a new query window and write your query.  When it is done executing, right click in the upper left of the results grid and select Save Results as
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,302 Points 20k badge 2x thumb
I think David has the more practical solution but it worth mentioning that with a little script you can read or write any type of text file (and binary files too) and that text file can be created, parsed or downloaded on the fly. In other words, you can create or manipulate the file dynamically using script. All you have to do is create a Blob and a FileReader objects using a little script:

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=544

All the details and examples are in my proposed Empower 2017 presentation entitled "File Mania":

https://quickbase-community.intuit.com/questions/1484441#answer_3172460


I am on pins and needles waiting on learning of acceptance of my presentations which I think is scheduled for this Friday.