I'm currently doing a night class which involves an Access project. The scenario, data & specifications are all supplied, so you'd think this'd be easy. NO. Let me explain, there's this one task , and I quote;
"...write SQL queries to mine the data as follows...extract data and produce a file suitable for export to another application.?
Now I know it makes sense to simply put a button on a form to export any table or query to an Excel file, but to do it with SQL has me really stumped.
Does anyone know how it can be done? I'm afraid I've only just started with SQL too, so if there is a solution, please be gentle with me [img]/forums/images/smilies/smile.gif[/img]