<div>
Your answer gave me an idea to the solution - thanks a lot.
</div>


Your answer gave me an idea to the solution - thanks a lot.

<div>
<div class="content wysiwyg-content">
I have 10 queries in Access that generate data in to 10 temporary access tables.<br />
My requirement is that data in these 10 tables be manipulated in a certain way to 3 tabs and then exported out in excel format.<br />
Is there any tutorial or guidance available to do this?
</div>
</div>


I have 10 queries in Access that generate data in to 10 temporary access tables.
My requirement is that data in these 10 tables be manipulated in a certain way to 3 tabs and then exported out in excel format.
Is there any tutorial or guidance available to do this?

Access tables data manipulation

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.