[AccessD] Convert Table in Design View to Excel?

Dan Waters dwaters at usinternet.com
Wed Jun 23 19:01:39 CDT 2004


Dave,

This works if the table is in datasheet view, but not in design view.  This
is a quick way to make the conversion!

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 5:24 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Convert Table in Design View to Excel?

Dan

While viewing the table.

File
export
select desired Excel File type ( 97,2000,xp, etc)

Dave
----- Original Message ----- 
From: "Dan Waters" <dwaters at usinternet.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Wednesday, June 23, 2004 6:12 PM
Subject: RE: [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

-- 
_______________________________________________
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




More information about the AccessD mailing list