Microsoft Office Tutorials and References
In Depth Information
2. Click the Browse button, navigate to and open the Level.02\Tutorial folder, click
Products , click the Open button, and then click the Link to the data source by
creating a linked table option button. The selected path and filename now
appear in the File name text box, and you’ve set the option to link to the data
instead of importing or appending the data. See Figure 8-36.
Figure 8-36
Linking to data in an Excel worksheet
filename of the linked file
(your path might be different)
option to link
to the file
3. Click the OK button. The Link Spreadsheet Wizard dialog box opens. See
Figure 8-37.
Figure 8-37
Linking to data in an Excel worksheet
checked box will use the
first row in the worksheet
as column heading names
data in the worksheet
to be linked
The first row in the worksheet contains column heading names, and each row in
the worksheet represents the data about a single product.
 
Search JabSto ::




Custom Search