Need 'INSERT INTO", not just "INSERT". :) At 03:40 PM 1/9/2003 -0600, you wrote: >I think this would fly in MS SQL server(which I usually use) but I'm getting >and error from access when I try to run it: > >INSERT tbOptions (tbQuestionsFK, Value, supplementalValue1, >supplementalValue2, supplementalValue3) >SELECT 20 AS tbQuestionsFK, tbContentClassifications.id, >tbContentClassifications.name, tbContentClassifications.description >FROM tbContentClassifications >where tbContentClassifications.tablePK >= 5 >AND tbContentClassifications.tablePK <=23 > > >It tells me "syntax error in INSERT INTO statement", even though it's a >insert select not a insert into. >Matthew P. Smith >Web Developer, Object Oriented >Naval Education & Training Professional >Development & Technology Center >(NETPDTC) >(850)452-1001 ext. 1245 >[EMAIL PROTECTED] > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
