Automatic export from QuickBase into Excel
Hello! There are a few parts to this project I'm trying to complete. First, I have specific filtered table reports I've created in QuickBase in multiple different tables. I'd like to automatically ...
Forum Discussion
You can do a "Web Query" from Excel. Under the Data tab select "From Web" (displayed on the far left) and browse to your QuickBase table and you are off to the races.
- Hi Dan, I've implemented this approach successfully and I'm able to obtain the data I need. 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
