Is this possible?
i want to have a sql statement which moves a record from one table to another, is this possible?
INSERT INTO the_new_table(column_list) SELECT column_list FROM your_other_table;
thank's for replying, this si the line i have put in
strSQL = "INSERT INTO savedmail (mailID, recID, content) SELECT (mailID, recID, content) FROM internalmail WHERE mailID =" & mailID & ""
and i am getting the error
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (comma) in query expression '(mailID, recID, content)'.
/year4/MMT4-155/move2.asp, line 23
line 23 is execute the sql,
any one know where its going wrong,
that's not a well formed SELECT statement. there shouldn't be paranthesis around the column list.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)