[RESOLVED] How to import table from Access into Excel including field names

Can someone please offer some VBA code to import a table from Access into Excel with field names included. I don't want to use 'connections' as those seem to lock the database. Thanks.