[AccessD] Convert Table in Design View to Excel?

Dan

This 'usually' works for ME.

Just Open the workbook,
go to the top left corner an click ( selecting the entire sheet
copy into the clipboard

Open access ( if not already open )
go to table
do a single right click
You hould be presented a menu with Past being an option,
select the Paste.

Some notes:
It makes any text feild 255 chrs.
Text fields that contain only numbers usually get rejected.

Dave

----- Original Message ----- 
From: "Dan Waters" <dwaters at usinternet.com>
To: "Database Advisors" <accessd at databaseadvisors.com>
Sent: Wednesday, June 23, 2004 5:04 PM
Subject: [AccessD] Convert Table in Design View to Excel?


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.

 

Thanks!

Dan Waters

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com