Import excel worksheet by range with non identical headers

[snoopy2003]

Hello,



I have an excel workbook with worksheet and access db with a table (headers count equals to fields count).

I want to check whether the first column header name equal to first table field name and then copy a range from the worksheet to the table
without the headers.


My problem is: Access keeps generating error message about non identical headers.

How can I do it ?

Thank you for your help

[thhui]

Try the same field names with excel range and access table.
It is the recommended answer.

You should ensure it is the same instead of checking it by access.

Access just compare the same headerName with fieldName in the table
and imports if it works.