Excel Link Starting at Row 2

[Jim]

Hello,
Does anyone know how to or have a macro that links an
excel file starting from a user defined row number. For
example, I have an excel file where field names start at
row 2. Starting at row 3 on down would be the recordset.

Jim

 

[Douglas J. Steele]

Create a named range, and tell Access that the first row is the field names.
If you're using DoCmd.TransferSpreadsheet, HasFieldNames is the 5th
argument, and the range name is the 6th.

 

[Jim]

Thank you that worked great!!

Jim

-----Original Message-----
Create a named range, and tell Access that the first row is the field names.
If you're using DoCmd.TransferSpreadsheet, HasFieldNames is the 5th
argument, and the range name is the 6th.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)





.