SQL - INSERT INTO / SELECT FROM, one field with SET value

[ironfelix717]

Hi,

Is it possible to provide a SET value in an INSERT/SELECT-FROM query??

EX:

       SQL = "INSERT INTO ToolingBuilds " & _
      "SELECT ToolID, ToolVersion, ToolCompID, ToolCompVersion, " & _
      "DateModified FROM TempTable;"

In the above, I need to insert all the fields from 'TempTable', but instead of inserting one the fields (say, Tool Version), I need to set the value instead.

Thanks

 

[plog]

Most likely in the SELECT do this:

SELECT ToolID, "MyValue" AS ToolVersion, ToolCompID ...

 

[ironfelix717]

Hi,

I get an error when using that.

"Query input must contain at least one table or query"

 

[plog]

What is your exact SQL?