Export sorted lists

  • Thread starter Thread starter Lupe
  • Start date Start date
L

Lupe

Hi,
I have a query that has personnel members with their respective departments
and additional info. I want to selectively download to Excel all personnel
but each department in their own spreadsheet.
Example: All departments starting with A will be downloaded in sheet A, all
departments starting with B will be downloaded in sheet B, etc.
Is this possible?
Regards, Lupe
 
Lupe,

You could use Office Automation to Open the Excel, create a new spreadsheet,
then loop through your recordset and write the values to each worksheet based
on the first letter of the department.

Google on: Access +Excel +Automation for some ideas on how to acomplish this.

HTH
Dale
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pagebreak in queries 1
Need query to return absence of record 10
Query Difficulty 9
Grouping rows based on header cells 2
how do i? 7
Using form to fill in query criteria not working 2
DSum in Query 1
help me 2

Back
Top