Re: Importing excel data from row 2

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

The only way to use TransferSpread*** action for this type of import is to
provide a range argument, such as A2:<something>.

However, I believe that ACCESS / Jet are smart enough to identify when you
have provided a range that is "bigger" than the actual data set, and they
only import the existing data.

So, try using a range of A2:IV65536 for the TransferSpread*** Range
argument. Let us know if this is successful.

--

Ken Snell
<MS ACCESS MVP>


"Tiffany" <Tiffany@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E42B4C3E-44B0-4C7D-9209-8EC70434AA21@xxxxxxxxxxxxxxxx
How do I just import everything from row 2 in the excel file??
I don't want to define a range, eg A2:V750, as each month when the data is
imported, it will be a different amount of rows. I just want to import
data
from row 2 downwards.
Any help would be much appreciated.


.

Quantcast