Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Running MSAccess Query thru ADO
Hi JerryKlmns, Thank you for your post. Please know that I am relatively new at ADO implementation. I simplified my code to make it easier to understand. However, I do not seem able to get your suggestion to work. As you suggested, I set up an MSAccess query that performs the Xtable and now...- LISpeedyG
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Running MSAccess Query thru ADO
Hi All, I posted this in the wrong thread earlier (ADP) sorry.. I hope this is the correct thread.. I have been trying to run a query that returns a pivot table from Access to Excel. I have been successful in some ways (non-pivot) but have been stumped with "syntax issues" when attempting...- LISpeedyG
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Running MSAccess Query thru ADO
All, I have been trying to run a query that returns a pivot table from Access to Excel. I have been successful in some ways (non-pivot) but have been stumped with "syntax issues" when attempting this current query. In trying pass the SQL argument I get syntax errors. I suspect it is because...- LISpeedyG
- Thread
- Replies: 0
- Forum: Microsoft: Access Project (ADP)
