MS Query can only read data, there is no functionality to update data.
Actually, you can type (for example) an INSERT statement into SQL
window and successfully execute it, but this isn't what you want.

Why not use a linked table? You don't need the MS Access application
to create a Jet database (.mdb file) with a linked table. You can do
all this on the fly using only Excel and ADOX. See the following links
(in these articles, read 'Jet' for the word 'Access' because the MS
Access application is not actually used):

Creating an Access(sic) Database
http://msdn.microsoft.com/library/de...ssdatabase.asp

Creating a Linked Table
http://msdn.microsoft.com/library/de...inkedtable.asp

--

sod wrote in message ...
Update tables in DB2 using input from Excel using msqry ( linked tables )

This is an working option in access. Can this be done from excel using msqry ? The odbc driver must of course be set with edit function.

I'd appriciate very much if someone out there could help me with this issue.