| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can Excel modify data in a Query?
I guess not...
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help to modify the query? | Excel Worksheet Functions | |||
| modify query with value in combo box | Excel Programming | |||
| Modify a data query ?? | Excel Programming | |||
| Stop to modify the SQL query manually entered into query ! | Excel Programming | |||
| Modify Web Query using macros? | Excel Programming | |||
Hybrid Mode
