Linking Excel file to Access when the first line doesn't contain column headings

Hi.  I have an Excel file (sample attached) where my heading rows are on the 3rd line.  If I wanted to be able to link this to Access, how do I let it know my column headings aren't in the first row, but rather the third?
Who is Participating?
John EastonConnect With a Mentor DirectorCommented:
The only way I can see to do what you want is to create a named range.  To do this, in Excel, select the data and the headings.  Then in the box which has the cell reference delete the cell reference and type a name e.g. mydata.

When importing to access you can then choose to import Worksheets or Named Ranges.  Select named ranges, then in the list pick the range you created above.  Then on the next screen tick first row contains headings.
daisypetals313Author Commented:
Thanks!  Quick and easy solution and did what I needed.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.