Forum Discussion

AdminEntry's avatar
AdminEntry
Qrew Cadet
8 years ago

Automatic download of QuickBase data to Excel spreadsheet

I'm using a data connection ("From the web") in Excel to automatically download the data that I need from QuickBase. The only issue I'm facing now is that from time to time my data connection seem...
Data import and export
AlisherNizamov's avatar
AlisherNizamov
Qrew Trainee
7 years ago
Hello,

I am looking into creating an excel query for a quickbase table. I used the Data - New Query - Web Query, in the field I insert the web site where the table sits and hit Enter. Excel returns a Navigator window where the table view shows a two-row four-column table that is not even close to what the actual table has.

My goal: I pull tables from quickbase on a regular bases and wanted to automate the operation by creating a web query and refreshing it every time I am ready to export tables from QB into excel. 

I have read the posts regarding my matter but the posts are old and the approaches are not working in my case.

Thank you in advance,
Alec.
AlisherNizamov's avatar
AlisherNizamov
Qrew Trainee
7 years ago
Juan, thanks for the response.

Here is what I am doing: in Excel I go to Data - New Query - From another Source - From Web - in the dialogue in the URL field I paste the link of the quickbase where the table sits - hit OK and below is what it displays. The headers in the display table are not what I have in the table in QB.