Darryl Collins
darryl at whittleconsulting.com.au
Thu Jul 25 23:15:26 CDT 2013
I usually use copyfromRS (copy from recordset) from Excel with an ADO hook into Access for this sort of thing. I know that works fine and is very reliable once you set it up. Just be aware that some JET functions will fail (such as using NZ for example) when using this method. There are ways around this sort of thing (Use iif(is Null..)) rather than NZ for instance). The other (sometimes more powerful options) is to hook an Excel Pivot table into access. A 3rd option maybe to export the report from Access and then import it into Excel as a sheet. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholas Lee Sent: Friday, 26 July 2013 1:37 PM To: Access Developers discussion and problem solving Subject: [AccessD] Import CrossTab query to Excel 2007 Hi All, Please help. I wish to import crosstab query into Excel 2007 (DATA->FROM ACCESS). The pop up box show almost all the table and query except crosstab. What should I do? Nicholas -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com