[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.