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