Exporting intelligently

[MintFlavor]

Hi ppl,
Working in ms access, i have tables storing details of assignments and people who are assigned for these jobs.

What i want to do now is to be able to export these data to an Excel sheet and present it into useful information
-> display a 'planning sheet' filled with data coming from my db.

I have never ventured in this before and would like to know more about the feasibility of this thanks to your past experience and realization.

Thanks a lot.
MintFlavor

[salvelinus]

DoCmd.TransferSpreadsheet ... is the usual way. You can transfer data from a table or a query.
If you want the Excel sheet to look pretty or if you have other requirements for it, you may instead want to create an Excel object through VBA & manipulate it that way.
Alternately, you could use Excel to import your Access data.