[AccessD] Export from Access to Excel

Collins, Darryl Darryl.Collins at anz.com
Thu Sep 17 00:07:54 CDT 2009


And whilst on examples...  Here are a couple I have made available that
use ADO.

Using Excel
http://www.excelyourbusiness.com.au/FormulaHelp.htm#FormulaExcelToAccess
Tnf

Using Access
http://www.excelyourbusiness.com.au/ms_access_page.htm#AccessImportFromE
xcel

Cheers
Darryl 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D.Tejpal
Sent: Thursday, 17 September 2009 2:54 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Export from Access to Excel

Arthur,

    Two of my sample db's mentioned below, might be of interest to you:

    (a) ExportAccessToExcelMultiSheets
    (b) ExportAccessToExcelAsPivotTable

    Both samples (in Access 2000 file format) are available at Rogers
Access Library. Link:
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45

    Sample (a) uses web browser control for displaying destination excel
workbook, enabling the user to manually select the starting cell for
exported data block. It uses a specimen .xls file as template
(optional).

    Sample (b), is not restricted to pivot tables alone and might be
found more convenient if you do not wish to install & register a web
browser control. It uses .xlt file as template (optional).

    Note: In both samples, use of template excel file is optional.

Best wishes,
A.D. Tejpal
------------

  ----- Original Message -----
  From: Arthur Fuller
  To: Access Developers discussion and problem solving
  Sent: Wednesday, September 16, 2009 21:57
  Subject: [AccessD] Export from Access to Excel


  Instead of the usual "blank sheet", I want to export to Excel using a
  template (XLT) file. Can anyone tell me how to modify the code so it
uses
  the template instead?
  TIA,
  Arthur
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

"This e-mail and any attachments to it (the "Communication") is, unless otherwise stated, confidential,  may contain copyright material and is for the use only of the intended recipient. If you receive the Communication in error, please notify the sender immediately by return e-mail, delete the Communication and the return e-mail, and do not read, copy, retransmit or otherwise deal with it. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of Australia and New Zealand Banking Group Limited ABN 11 005 357 522, or any of its related entities including ANZ National Bank Limited (together "ANZ"). ANZ does not accept liability in connection with the integrity of or errors in the Communication, computer virus, data corruption, interference or delay arising from or in respect of the Communication."




More information about the AccessD mailing list