Link Database Table To Existing Excel

[uneek78]

How do you link an Access Table to an Existing Excel spreadsheet? And when you put data in either the database or the spreadsheet will it reverse populate the other? Like, if I put something in Excel will it be in Access and vice versa?

 

[boblarson]

How do you link an Access Table to an Existing Excel spreadsheet?

Depends on which version you are using as to the exact steps but basically the same as linking to an Access database but you select the file type from the dropdown when the dialog comes up after selecting the Import/Link option.

And when you put data in either the database or the spreadsheet will it reverse populate the other? Like, if I put something in Excel will it be in Access and vice versa?

You can't update a linked spreadsheet from Access (you used to be able to but a lawsuit settlement had Microsoft remove that functionality). Access will see the updates to the Excel sheet.

 

[uneek78]

That hurts! The whole joy would have been that information could be entered through a form in access and manipulated in the excel spreadsheet for 1 of my more tech savvy users.