Excel Link Starting at Row 2

J

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
 
D

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.
 
J

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!)





.
Click to expand...
 
Top