Can Excel modify data in a Query?

B

Basilisk96

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

ilia

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

Basilisk96

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
prevet users to view and modify MS query 2
How to modify the Query Tables attached to a sheet in a excelworkbook 3
ADO retrieval from close workbook-data type issue 2
help to understand 'querytable' 1
Passing data to an event handler 3
EDITTING QUERIES RELATED TO QUERY TABLE 1
Changes to working code 5

Top