Runtime Error 3001 Invalid Arguement

[Temo98]

Hey All -

I am running the below SQL via VBA in Access 2003, and I getting a runtime error 3001 invalid argue. I have doubled checked that the columns exist in both tables, as well as verified the the spelling within both tables. However I cant seem to get past the error. Any assistance you can provide would be greatly appreciated. Thanks in advance.

DoCmd.RunSQL "INSERT INTO MINOUTL_Master ( [Item Nbr], ITMST, Effective, Expire, MINOUTL, Time_Stamp ) " _
& "SELECT tbl_MINOUTL_Intermediate.[Item Nbr], tbl_MINOUTL_Intermediate.ITMST, " _
& "tbl_MINOUTL_Intermediate.Effective, " _
& "tbl_MINOUTL_Intermediate.Expire, tbl_MINOUTL_Intermediate.MINOUTL, tbl_MINOUTL_Intermediate.Time_Stamp " _
& "FROM tbl_MINOUTL_Intermediate;"

 

[Joe4]

Check to see that the Data Type of each field in your "destination" table matches exactly the field of the table you are trying to select from (your "source" table).
Also check to make sure that none of the data you are trying to paste in violates any of the rules of the table you are trying to paste it into. For example, if a field cannot be Null and one of your records has a Null value in that particular field.

You can also check to make sure that your Select query has valid syntax by checking just that part, i.e. make sure that the following code does not return any errors.

DoCmd.RunSQL "SELECT tbl_MINOUTL_Intermediate.[Item Nbr], tbl_MINOUTL_Intermediate.ITMST, " _
& "tbl_MINOUTL_Intermediate.Effective, " _
& "tbl_MINOUTL_Intermediate.Expire, tbl_MINOUTL_Intermediate.MINOUTL, tbl_MINOUTL_Intermediate.Time_Stamp " _
& "FROM tbl_MINOUTL_Intermediate;"

 

[Norie]

Does the query execute if you try it manuall?

 

[Temo98]

1

 

[Temo98]

Quick update...

I created a query and copied the select portion of the SQL and it ran without a hitch...So that leaves me at a loss...

 

[Joe4]

Now try creating the WHOLE query (not just the Select part) to see if you can run that manually.
If not, take a look at the things I mentioned regarding fields in my previous post.