Mark A Matte
markamatte at hotmail.com
Fri Mar 5 08:58:32 CST 2004
>but if all I needed was a portable emailable snapshot of predictably >transferable data, I would consider those methods. This is exactly what I need...what I didn't want to do was export 2 files for the other user to import...just 1 file with 2 worksheets...the excel file will almost never even be viewed...just imported. >Although DoCmd.TransferSpreadsheet will create a sheet for each named query >or table that you export to a file at a target path If I understand this statement...Using the tranferspreadsheet will automatically create another worksheet if I use the same target path? Thanks, Mark >From: "Jürgen Welz" <jwelz at hotmail.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, 04 Mar 2004 22:45:53 -0700 > >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 > >-- >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _________________________________________________________________ Create a Job Alert on MSN Careers and enter for a chance to win $1000! http://msn.careerbuilder.com/promo/kaday.htm?siteid=CBMSN_1K&sc_extcmp=JS_JASweep_MSNHotm2