Importing Huge Data from Microsoft Excel containing Multiple Sheets into Microsoft Access

[earthworm]

When I am trying to import a huge data into Access from Excel containing multiple sheet I am getting an error of Unexpected Error from external database driver (1).
I am using office 365.

Secondly the data which I am importing from Excel is not in Proper Table form (Ctrl +T) . Does this means that this is the issue because it not possible for me to convert each sheet into table.

 

[welshgasman]

I would doubt it. it is just data after all.
How about one sheet at a time?
Also show your code.

 

[Micron]

IMO the best approach is to link the sheets in Access as tables, then build properly normalized tables from scratch and ensure each field has the correct data type (and anything else required, such as validations). Then write the linked sheet data into these tables. That way, you will be sure to eliminate the probability that you will run into "Data type mismatch" errors at some point.