ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   edit query in Escel 2007 pulled from Access? (https://www.excelbanter.com/excel-discussion-misc-queries/228355-edit-query-escel-2007-pulled-access.html)

maf

edit query in Escel 2007 pulled from Access?
 
In Excel 2007 I am using MS Query to pull data from Access 2007. I can do one
pull, but cannot edit the query. It gives me a message about not being able
to move cells. I am probably missing something, but not sure what!

CLR

edit query in Escel 2007 pulled from Access?
 
I don't use 2007, but my way around this problem with other versions is to
Record a macro while creating the Query, and then edit the macro..........

Vaya con Dios,
Chuck, CABGx3



"MAF" wrote:

In Excel 2007 I am using MS Query to pull data from Access 2007. I can do one
pull, but cannot edit the query. It gives me a message about not being able
to move cells. I am probably missing something, but not sure what!



All times are GMT +1. The time now is 01:54 AM.

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