AdminEntry
8 years agoQrew Cadet
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 seems to "forget" my QuickBase credentials and the data download fails, until I go into Connection Properties and click on "Edit Query". When I do this, Excel attempts to open the QuickBase report in a browser window within the Edit Query dialog box and asks me to enter my QuickBase credentials. Once I re-enter my credentials, the data download executes successfully.
I've attached a screenshot of the Edit Query dialog box.
I don't want to have to do this every time. Is there a way to store the credentials within the connection string?
Thanks in advance.
Juan
The only issue I'm facing now is that from time to time my data connection seems to "forget" my QuickBase credentials and the data download fails, until I go into Connection Properties and click on "Edit Query". When I do this, Excel attempts to open the QuickBase report in a browser window within the Edit Query dialog box and asks me to enter my QuickBase credentials. Once I re-enter my credentials, the data download executes successfully.
I've attached a screenshot of the Edit Query dialog box.
I don't want to have to do this every time. Is there a way to store the credentials within the connection string?
Thanks in advance.
Juan