Question (A Tuff 1 but) Any best solution for excel (import & export) in access db

[admin_access]

hello everyone,

Is there any possibility to import data (tables, queries, statistics,pie charts) from excel and exactly fit or update in access db with respective fields and queries, then after updating access db again export the data in it back to excel with respectives cells of it to be modified as well............​

If there is any code or algorithm available to understand and meet the complexity in matching data inspite of data inconsistencies, such as case-sensitive,blank fields,etc ....to be dealt with will be greatful.​

Thanks in advance.​