Access to Excel link

  • Thread starter Thread starter Hardworker
  • Start date Start date
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. Yes, data from Excel can be copied to an Access table in two ways:
a) importing the data instead of linking it
b) running an append query from a linked Excel table to an Access table.

2. No. An Excel worksheet has a one-to-one relationship with an Access
table. However, in Excel you could create another worksheet that merges two
or more worksheets, and then link that into Access.
 
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)?
Click to expand...

Yes to both.
 
Back
Top