Thanks Dave! that worked. (for the record, row 1 wasn't the header
row .. the header row started on a variable row for each file to be
im****ted. BAD DESIGN, but not under my control. )
On Jul 23, 12:27=A0pm, Klatuu <Kla...@[EMAIL PROTECTED]
> wrote:
> Yes it changes things.
>
> First, are you starting in A2 because row 1 is header info?
> That is okay, but be aware in TransferSpreadsheet, one of the options is
> whether or not the first row im****ted is the field name for the column.
=
=A0If
> you are im****ting into an existing table, you set that to False and it
wi=
ll
> use the field names defined in the table. =A0If you im****t to a new
table=
, you
> will end up with field names F1, F2, F3, etc.
>
> But the simple answer is you can define the range in the
> TransferSpreadsheet. =A0For example, if you wanted to start at row 20
and
> im****t columns C through Z, you would use somethingl like:
>
> docmd.TransferSpreadsheet acIm****t,,"_boo","c:\do***ents and
> settings\XXXX\my do***ents\Project Listing Re****t
2008.xls",false,"C20:Z"
>
> --
> Dave Hargis, Microsoft Access MVP
>
|
