DWUTKA at marlow.com
DWUTKA at marlow.com
Fri Mar 5 12:29:52 CST 2004
ADO works quite well too, just doesn't do the formatting. However, if you format a 'blank' Excel spreadsheet, that works well. Still doesn't handle 'conditional' formatting then, unless you put that into excel itself. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jürgen Welz Sent: Thursday, March 04, 2004 11:46 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Export to Mutiple Excel Sheets 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-requ est at databaseadvisors.com?subject=subscribe> >List-Archive: <http://databaseadvisors.com/pipermail/accessd> >List-Unsubscribe: ><http://databaseadvisors.com/mailman/listinfo/accessd>,<mailto:accessd-requ est 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=htt p://hotmail.com/enca&HL=Market_MSNIS_Taglines -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com