Export from Access to Excel

[Giulio Benvenuti]

Hello
How can i export from access to excel all or filtred records?
I have a "Table = Database" with a "Query = [Query Pratiche Studio Totale 2]". From this Query i have a "Form = ComboBoxCustomer" which is a subform in "Form = ComboBoxSearch" where i have different boxes to search different words like name, lawer, etc.


Now i want export to excel filtred records in subform ComboBoxCustomer with a button (maybe VBA?). I would like create a table where i have just some specific columns.
Is it possible?
Actually if i try to export to excel i have the boxes' ComboBoxSearch but not records' columns.

[June7]

Could export a simple report.

If you want to allow different fields to be included in export, that will probably require VBA using DAO and QueryDefs to modify query object then export query.