H
Hardworker
I have two questions regarding Access/Excel linking:
1. I know that if an Access table is linked to an Excel spreadsheet it
cannot be edited for whatever reason but can data in that linked table be
read and copied into another Access table (using an append query) where it
can be subsequently edited?
2. Can an Access table be linked to more than one Excel spreadsheet (in the
same Workbook)?
Comments will be much appreciated.
1. I know that if an Access table is linked to an Excel spreadsheet it
cannot be edited for whatever reason but can data in that linked table be
read and copied into another Access table (using an append query) where it
can be subsequently edited?
2. Can an Access table be linked to more than one Excel spreadsheet (in the
same Workbook)?
Comments will be much appreciated.