Nicholas Lee
Nicholas at nagase.com.my
Fri Jul 26 00:40:30 CDT 2013
Darryl, Thanks. I like the method of "hook an excel pivot table into access". So, there is no way to import the whole crosstab query into Excel, right? Nicholas -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins Sent: Friday, 26 July, 2013 12:15 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Import CrossTab query to Excel 2007 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com