| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variables in a query
gocush wrote: Assuming the user has permission access to the db, do you also have or can you explain how to add/edit/delete records stored in Access via Excel? Do you mean via MS Query. It can be done but not via the GUI query builder tools. You will have to type the appropriate SQL DML (INSERT INTO/UPDATE/DELETE respectively) yourself. Note that if you do this you will lose support for parameters because the query cannot be displayed 'graphically'. Jamie. -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
| Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
| User Defined Variables in MS query cause a problem to import data | Excel Discussion (Misc queries) | |||
| Newbie Macro Query - Clearing Variables and Assigning a Variable | Excel Programming | |||
| Web Query with looping variables in the URL | Excel Programming | |||
Hybrid Mode
