Import Access table to Excel

[Custos]

Hi

I would like to import an access table / query in to excel but every time i try i fail, i have searched the web for a DAO answer but nothing yet, can anyone please help?

Thanks
Paul

[ndendrinos]

Hello Custos.
Not sure why you would need DAO except if you insist using VBA for this.
This example does not but does the work , Maybe this helps ?
If you want to try it unzip the file on your desktop and follow the instructions shown in the Excel file

[geekgirlau]

If you want to transfer Access to Excel via code, you can do this fairly simply using TransferSpreadsheet.