Hello,
I’ve done several searches over the last few weeks hoping to find a solution to this. I suspect it doesn’t exist but thought I would try here now that I’ve registered an account.
When linking or importing an excel table, is there any way to define what row the column headings are in?
I normally have a lot of notes or legend information in my first few excel rows. I don’t need this info in the access database linking to the table, and of course access will interpret columns incorrectly if I don’t get rid of it in the excel table.
For the moment, I will create a new sheet that copies all the info from the originating sheet, and then link this to access. But I just don’t like too many garbage rows or sheets since they tend to confuse me or others if we come back to the excel file at a later date.
Thanks again. Excuse the flood of all my recent questions. I have a backlog of questions since I haven’t been certain which help forum to join the past few years. So many out there, each with what seems their own strengths.
