[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