Dan Waters
dwaters at usinternet.com
Wed Jun 23 19:08:36 CDT 2004
TRANSPOSE!?! How long has that been there? This is a new toy! Thank you Stuart! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Wednesday, June 23, 2004 5:29 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Convert Table in Design View to Excel? On 23 Jun 2004 at 16:04, Dan Waters wrote: > Is there a way to quickly create a spreadsheet from a table where the > spreadsheet looks like the table with the fields listed in the 1st column > from top to bottom? > > > > Is there an easy way to do this? I could write some utility code, but I > thought there might be an easier way. > Open the table and use the "Analyse with Excel" tool to create a spreadsheet. In the spreadsheet, select all the cells, and do a "Copy" then select a blank cell, do a Right Click, Paste Special and select "Transpose" -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com