In this chapter, we connect to the created Payments table from a new workbook under Nick's credentials.
Let's create a new workbook and save it as payments-nick.xlsx.
Then let's run the Data Connect Wizard.
The wizard contains the same connection steps as described above.
Let's connect to the dbo69.Payments table. You may use search. Uncheck Enable Query List on the ribbon.
In this step, you may check the fields to select and the fields to use as filters. We will learn this in the next chapter.
Now you may click OK and insert the table at cell B3.
We have an editable table in Nick's workbook. Alex and Nick can work now in their personal workbooks.
The table has an ugly format, unlike Alex's table. We will solve this in Chapter 7.