Moving Data from Access to Excel with VBA

[blr]

Hi.

I need to move data from an Access From which extracts data from two tables to an Excel Spreadsheet.

I can move single values between the two with VBA - no problem - but I don't know how to move a whole column at a time and how to insert the whold lot into excel.

Can anybody give me a clue of what functions to look for or pages which has a good example? I would really appreciate it.

I think it's quite simple task - I just can't get my head around it.


Thanks!