excel vba courses - Excel External Data

Hi Daniel

Thanks for your question.

You can export data from either from an Access Query or Table into Excel pretty easily.

Simply open the Access database and go to the database window. Right click on the table or query and from the resulting context menu select export. You will then be prompted to identify the format you wish to use; in this instance you would select the relevant version of Excel and then click export.

A new workbook will then be created and the data exported to it.

Regards

Stephen