Search code examples
sql-serverdatabasequickbase

Exporting tables from QuickBase

I am assigned with the task of taking all tables and records we have within QuickBase and importing them into a new database in MS SQL Server. I am an intern so this is new to me. I have been able to export all tables except two of them into CSV files so that I can import them into SQL Server. The two tables that will not export show a QuickBase error saying that the report is too large and the maximum number of bytes in report have been exceeded. My question is can someone recommend a work around for this? And also, do the CSV files have to be located on the server to import them, rather than have them stored on my machine?

Thanks in advance for any help.

Solution

  • When you export to CSV files, those files download from the browser onto your local machine, NOT the server. If you are running into issues with reports being too large, the filtering workaround above is a good enough.

    The other possibility is to use the QuickBase API here:

    http://www.quickbase.com/api-guide/index.html

    Specifically, API_DoQuery is what you want to use.