I need some help. I have exported the regions table out of access to sql but keep getting the error code

Msg 213, Level 16, State 1, Line 1 Column name or number of supplied values does not match table definition

What do I need to do to fix it so it will export all the data correctly? Below is the code in sql that executes properly. I have exported from access using OBDC database which everything tells me I have done correctly when running a test and tells me my information was imported correctly and successfully. However when I go to insert the data i am getting error codes.

CREATE TABLE Regions (RegionID int not null, RegionName varchar(40), CONSTRAINT PK_Regions PRIMARY KEY (RegionID));

Which again the above code runs and creates the table fine however when exporting the data over that needs to go into the table it does not export.

When I do the following command below I get the error message: Msg 213, Level 16, State 1, Line 1 Column name or number of supplied values does not match table definition.

INSERT Regions SELECT * from tmpRegions

Msg 213, Level 16, State 1, Line 1 Column name or number of supplied values does not match table definition.

How do I fix this? Am I doing something wrong in the exporting process?