[AccessD] Convert Table in Design View to Excel?

Dave,

I've used this as well when I'm trying to go from Excel to Access.  But here
I'm trying to go from an Access table (in Design view) to a spreadsheet.
The normal copy/paste method doesn't work for me.  

Thanks,
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dave Sharpe
Sent: Wednesday, June 23, 2004 4:42 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com