Is there any place where I can see examples of SQL queries in access VBA? I know some SQL stuff and if i find the right format i might pull out my program. I'm using ADODB in an excel workbook from where i want to automatically create/update some student info. I had no problems creating I have problems updating cause of the errors. Any idea/link is welcomed.
You can graphically create some queries in MS Access in the query section, then look at the actual SQL query by selecting SQL View from the view menu.
Though if you want/need to get more heavily into SQL, a good book is the only way to learn.