Access 2000

How do I link a table to excel table so if I add or change things it changes in the other.

Bub :rolleyes:

The way I link an Access Table to an Excel worksheet is to...

1) Open Excel file
2) Under Menu option Data select Import External Data
3) The import external data dialogue box appears
4) click on the properties first
5) On the external data range properties dialogue box check off how you want to Refresh data
6) Also on the external data range properties dialogue box choose how you want the data refresh. (insert cells...insert entire row... overwrite existing cells)
7) check okay to every thing and then select where to grab the datasource

If you need further instructions let me know.

thanx I am going to try it and let you know :D