[AccessD] Excel Import

Thanks!!

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com

RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
21231-3305

410-537-6098 direct | 410-276-2136 fax | www.rtkl.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D.TEJPAL
Sent: Wednesday, November 22, 2006 9:42 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Excel Import

    Updating of data in Access db via import or link from Excel
workbook, based upon dynamic named range is demonstrated in my sample db
named ExcelToAccess, available at Rogers Access Library (other
developers library). Link -
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Tejpal,A.D.
 
    The process is driven from excel end. Data blocks can be located
anywhere on any of the worksheets. Progressive data transfers, involving
more than one sheet (a sheet at a time), can be carried out as required.

    Two alternative styles are covered:
    (a) Select top left column heading of data block and execute.
    (b) No need to select any cell. Data block on active sheet will get
transferred.
 
A.D.Tejpal
---------------

  ----- Original Message ----- 
  From: Gustav Brock 
  To: accessd at databaseadvisors.com 
  Sent: Tuesday, November 21, 2006 16:58
  Subject: Re: [AccessD] Excel Import


  Hi Don

  Perhaps this about Dynamic Named Ranges:

  http://databaseadvisors.com/pipermail/accessd/2006-March/042838.html 

  Unfortunately, exactly such a range can _not_ be used as the source
when linking or importing.

  /gustav

  >>> Donald.A.McGillivray at sprint.com 21-11-2006 00:31:00 >>>
  True, but the inserted rows need to be ABOVE the last row in the
existing range in order for this to work, no?  Not such a big deal if
you're adding a row or two, but when adding large blocks of data, it can
be a pain to insert exactly (or slightly more than) the number or rows
you want before adding the data.  You definitely don't want to insert
fewer than you will need.

  I seem to remember somebody (Gustav?) posting some code a few months
back that managed the dynamic expansion of a named range in Excel.
Don't remember how it worked, or anything else about it, but it looked
like a useful thing for situations like this.  Does that ring a bell
with anybody else?

  Don
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com