PDA

View Full Version : Import Access table to Excel



Custos
04-12-2007, 05:04 AM
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
04-12-2007, 06:46 AM
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
04-16-2007, 10:12 PM
If you want to transfer Access to Excel via code, you can do this fairly simply using TransferSpreadsheet.