[AccessD] Export to Mutiple Excel Sheets

Jürgen Welz jwelz at hotmail.com
Thu Mar 4 23:45:53 CST 2004


Although DoCmd.TransferSpreadsheet will create a sheet for each named query 
or table that you export to a file at a target path, my predisposition to 
keep it simple and fast is circumscribed by constraints of reliability, 
error management, data validation and format control that dictate Excel 
automation.  If you're just dumping a bunch of pure text and integers into a 
sheet, no problem.  If you've got strings like '02E234', Excel will 
arbitrarily assume that it is a number in exponential notation and I've had 
that kind of issue bite me from time to time in the past.

Using automation, you can insert sheets in a particular order, set column 
widths, row heights, sorts, filters, do conditional formatting, name ranges, 
set titles, headers, protection ....  My export/imort needs have never been 
met by the docmd methods, but if all I needed was a portable emailable 
snapshot of predictably transferable data, I would consider those methods.



Ciao
Jürgen Welz
Edmonton, Alberta
jwelz at hotmail.com





>From: <Oleg_123 at xuppa.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: <accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Export to Mutiple Excel Sheets
>Date: Thu, 4 Mar 2004 23:20:37 -0500 (EST)
>MIME-Version: 1.0
>Received: from mc2-f12.hotmail.com ([65.54.190.19]) by mc2-s17.hotmail.com 
>with Microsoft SMTPSVC(5.0.2195.6824); Thu, 4 Mar 2004 20:22:01 -0800
>Received: from databaseadvisors.com ([209.135.140.44]) by 
>mc2-f12.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Thu, 4 Mar 2004 
>20:21:05 -0800
>Received: from databaseadvisors.com (databaseadvisors.com 
>[209.135.140.44])by databaseadvisors.com (8.11.6/8.11.6) with ESMTP id 
>i254KaM02761;Thu, 4 Mar 2004 22:20:36 -0600
>Received: from heck.bay9.com ([66.28.60.200])by databaseadvisors.com 
>(8.11.6/8.11.6) with ESMTP id i254KUM02705for 
><accessd at databaseadvisors.com>; Thu, 4 Mar 2004 22:20:31 -0600
>Received: from xuppa.com (localhost.localdomain [127.0.0.1])by 
>heck.bay9.com (Postfix) with SMTP id CCBDA5B500for 
><accessd at databaseadvisors.com>;Thu,  4 Mar 2004 23:20:37 -0500 (EST)
>Received: from 24.187.36.171 (proxying for unknown)(SquirrelMail 
>authenticated user Oleg_123)by heck.bay9.com with HTTP; Thu, 4 Mar 2004 
>23:20:37 -0500 (EST)
>X-Message-Info: jl7Vrt/mfspXc7/cLcma3MAwjiq6mK2F
>Message-ID: <3049.24.187.36.171.1078460437.squirrel at heck.bay9.com>
>In-Reply-To: <BAY1-F661Ed28kIN4Mm00010855 at hotmail.com>
>References: <BAY1-F661Ed28kIN4Mm00010855 at hotmail.com>
>X-Mailer: SquirrelMail (version 1.2.10)
>X-BeenThere: accessd at databaseadvisors.com
>X-Mailman-Version: 2.1.4
>Precedence: list
>List-Id: Access Developers discussion and problem 
>solving<accessd.databaseadvisors.com>
>List-Help: <mailto:accessd-request at databaseadvisors.com?subject=help>
>List-Post: <mailto:accessd at databaseadvisors.com>
>List-Subscribe: 
><http://databaseadvisors.com/mailman/listinfo/accessd>,<mailto:accessd-request at databaseadvisors.com?subject=subscribe>
>List-Archive: <http://databaseadvisors.com/pipermail/accessd>
>List-Unsubscribe: 
><http://databaseadvisors.com/mailman/listinfo/accessd>,<mailto:accessd-request at databaseadvisors.com?subject=unsubscribe>
>Errors-To: accessd-bounces at databaseadvisors.com
>Return-Path: accessd-bounces at databaseadvisors.com
>X-OriginalArrivalTime: 05 Mar 2004 04:21:05.0359 (UTC) 
>FILETIME=[46AA15F0:01C40269]
>
>Mark,
>
>I thought that its possible to specify sheets in export macro; is it so ?
>
> > Hello All,
> >
> > I need to build an export/import function into an A97 db...I want to
> > export/import 2 query results...1 to each sheet in a new excel workbook.
> >   Any suggestions/directions to head?
> >
> > Thanks,
> >
> > Mark A. Matte
> >
> > _________________________________________________________________
> > Fast. Reliable. Get MSN 9 Dial-up - 3 months for the price of 1!
> > (Limited-time Offer)
> > http://click.atdmt.com/AVE/go/onm00200361ave/direct/01/
> >
> > --
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
>
>
>
>-----------------------------------------
>Get Breaking News from CNN, ABC, NBC, CBS Now.
>http://www.xuppa.com/news/?link=webmail
>
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
MSN Premium: Up to 11 personalized e-mail addresses and 2 months FREE*   
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines




More information about the AccessD mailing list