MSQuery editing source data?

D

Dave H

I want to be able to edit records in the source database that are
returned to my excel spreadsheet from an access database using MSQuery.
While in the the MSQuery window I can choose under records allow edit,
I then can edit my records. Once I return the query to excel I lose
that functionality. Is there a way to edit records using MSQuery?
 

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

Trying to run a MSQuery from Excel as a Scheduled Task 1
Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0
creating a query using MSQuery 0
viewing newly created access queries in excel via msquery 0
Using MSQuery on a tab in the current workbook 0
MSQuery Parameter in WHERE defaulting to All 1
Excel-MSQuery Out Of Memory error 0
Getting external data from Access 2007 using msquery 0

Top