Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
maf maf is offline
external usenet poster
 
Posts: 4
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 - Query MS Access DB James C. Excel Discussion (Misc queries) 0 February 19th 09 03:34 PM
Excel 2007 Query Wizard problem with Access 2007 extensions Showdad Excel Discussion (Misc queries) 0 December 4th 08 05:57 PM
Import Access query to Excel 2007 Office Productivity Consultant Excel Discussion (Misc queries) 8 November 14th 08 05:52 PM
excel 2007 right click edit query Koppite412 Excel Worksheet Functions 1 September 3rd 08 06:26 PM
access-type query in excel 2007 newyorkjoy Excel Discussion (Misc queries) 1 August 2nd 07 05:43 PM


All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"