ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   MSQuery editing source data? (https://www.excelbanter.com/excel-discussion-misc-queries/84419-msquery-editing-source-data.html)

Dave H

MSQuery editing source data?
 
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?


All times are GMT +1. The time now is 02:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com