ADO Connection question

[AlexanderBB]

Hi,

I have a connection between Excel and Access. From Excel, I query Access and use the Recordset method to put the data into a sheet.

Can I use this to somehow Update or Edit an actual query that's in Access ?

Please advise yes or no. I think its No !

Thanks, ABB

 

[AlexanderBB]

It's a great example of how good this forum is. I learned LOTS from this thread and cleared a major stumbling block. Many thanks, you two are brilliant

Cheers, ABB