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;"

[westconn1]

does the select part work, without the insert?

probably just a typo on posting, but you are missing a quote at the start of the 3rd line

[Temo98]

I broke apart the select from the insert portion of the query, and it threw an error of using a valid SQL query. However, I can't find any errors in the SQL that I wrote. Below is the modification that I made to run the select portion only.

And you are correct it was a typo as the orginal code included the necessary quotation marks.

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;"

[westconn1]

no line continuation on line 2?

[visualAd]

Does the query run if you paste it into an access query object? If not, what is the error?

Also, DoCmd.RunSQL doesn't run SELECT statements as they return recordsets. To test it you need to you CurrentDB.Execute.

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;