edit query in Escel 2007 pulled from Access?

M

MAF

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!
 
C

CLR

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
 

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

Getting query data from Access 1
Error Editing an MS Query in Excel 1
Excel 2007 / MS Query - editing existing query to another sheet 0
PIVOT TABLE 3
Using MS Query in Excel 2007 4
Using MS Query with Excel and Access 2007 3
No Results returned from Access query 3
Access Print Files from Query Results 0

Top