Can Excel modify data in a Query?
 

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

Can Excel modify data in a Query?
 

I guess not...

Can Excel modify data in a Query?
 

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 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

Can Excel modify data in a Query?
 

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


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