Can you convert an Excel data table to an access database?

Everything is reference by field names and (if needed) criteria to identify a record. If you are converting an Excel data table to an Access database you can’t just import the data. You have to understand relational data structures. I can see one main problem with your database.
For More Information Please Refer:
https://answers.microsoft.com/en-us/msoffice/forum/all/new-to-access-convert-excel-formula-for-use-in/19774f35-6a6c-4690-94ff-cdb45d5d79a1
You May Also Like to Read: