RE: Transact SQL

Michael Several problems here 1. You need the keyword VALUES before the open brace. 2. You need to separate the string values with comma rather than semicolon 3. You cannot mix constants and SELECT in the same insert statement, you can mix in an update however. Hope this helps Keith -> -----Original Message----- -> From: Michael Andreas [mailto:dachrinne@t-online.de] -> Sent: Thursday, March 11, 2004 9:11 AM -> To: informix-list@iiug.org -> Subject: Transact SQL -> -> -> Hi, -> -> the following command is correct in other db's -> but informix allways reports a message "syntax error" -> why? -> -> INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', -> 'C:\\Access.mdb';'admin';'', tab) SELECT * FROM tab; -> -> ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ********************************************************************************** sending to informix-list