Saving a single table

[mitch05d]

I want to import a single table in excel from access. How can I save this single table away from batabase as a whole. Or a better question how can I just import one table into axcel.

[ranman256]

export to excel with a macro
importExport, export, excel...

or 1 vba command
docmd.TransferSpreadsheet acExport ,acSpreadsheetTypeExcel12 ,tbl,file,true