[AccessD] Excel Import

Well, guys...don't sweat it too much.  I'm having to go through hoops right
now, while I wait on our damned MIS person to finally give me an ODBC access
to the application database.  In the meantime, I am downloading data, and
loading it into my own db to work with.  Ultimately, I'll have linked tables
and won't have to do this anymore.

I just found it to be an extremely odd thing to encounter.  Never ran into
this before....and I've done a LOT of excel imports.  {sigh}

Thanks for the advice.

Regards,

Keith

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of McGillivray, Don
[IT]
Sent: Monday, November 20, 2006 6:31 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Excel Import

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

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Monday, November 20, 2006 3:12 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Excel Import

If you insert a new row at the bottom of the range, you don't have to
redefine the range -- Excel does it for you automatically. You could come up
with a macro that does the work for you. I swear, I wrote about that, but
I'd never find it now. But, here's how it would go -- you'd enter a record,
press Ctrl+I or some other keyboard hot key combination to imitate a macro
that would insert a new row at the bottom of the range and position your
cursor at the first cell in the new row -- that way, Excel is constantly
extending the range. 

Susan H. 

Thanks.  This worked.  Although, for an ongoing process...I can just see me
forgetting to re-define my range...and not uploading all the proper data.
:(  For now, however...this worked.  :)


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


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