Software

Ask something
Discussion Locked

Linking 2 programs

0 helpful
3 replies

by waverly.nichols

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Can someone give me step by step instructions for linking excel and access database. Also can you link the worksheets in a workbook to automatically update when new data is entered?

3 replies

by dklippert

In Access, choose Tables on the Object bar.
Click New and choose Link table
Change Files of type to Excel and click link
Follow the directions with the Link Wizard.
Changes in either progam will update the table.

This discussion is closed to new replies.