Excel Link Starting at Row 2

  • Thread starter Thread starter Jim
  • Start date Start date
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
 
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.
 
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...
 
Back
Top