B
bubtrauma
Guest
Access 2000
How do I link a table to excel table so if I add or change things it changes in the other.
Bub
How do I link a table to excel table so if I add or change things it changes in the other.
Bub
There may be more than one way to do this
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.
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.
B
bubtrauma
Guest
thanx I am going to try it and let you know 
