Application Note for QuNect ODBC for Quick Base

Excel 365 without DSN or Password

To create an Excel 365 spreadsheet you can share with others without sharing your password or requiring them to configure a DSN please follow these steps. Connect to an ODBC data source as indicated below.

Choose the last entry in the list of DSNs which is the "None" choice.

Then open up the "Advanced options" and enter the following into the "Connection string" text box:

		USERTOKEN=yourusertoken;;Driver={QuNect ODBC for QuickBase}

make sure to substitute your usertoken and Quick Base realm name.

On subsequent dialogs you will be prompted for your username. You must enter the username associated with the usertoken you placed in the connection string. However when prompted for a password you can leave the password text entry box blank.