If I set up a query table on a worksheet and use an Access db or
another Excel file as the data source, is it possible to modify the
data from Excel itself? If so, by what methods?

Cheers,
-Basilisk96

I guess not...

You can use MS Query to get into an Access database, in which case you
can query it in any way you want.


On Dec 5, 5:14 pm, Basilisk96 <basilis...@gmail.com> wrote:
> If I set up a query table on a worksheet and use an Access db or
> another Excel file as the data source, is it possible to modify the
> data from Excel itself? If so, by what methods?
>
> Cheers,
> -Basilisk96

I understand that I can query it, but can I modify the underlying data
from Excel?


ilia <iasaf...@gmail.com> wrote:
> You can use MS Query to get into an Access database, in which case you
> can query it in any way you want.