Did I leave something out of my Query? 1

[MacroAlan]

I created this query in VBA and tried it in the Access Design View and get error 3134 which is totally inadequate.

INSERT INTO [Schema] ( SchemaName, SourceFileType, SourceSheet, SourceDelimiter, DateStamp,UserID ) 
WHERE (((Schema.SchemaName="Beattles_schema") AND (Schema.SourceFileType="xls") AND (Schema.SourceSheet="PROFILES-_Sample.xls") AND (Schema.SourceDelimiter="Excel") AND (Schema.DateStamp=#12/20/2006 08:37:01#) AND Schema.UserID="aardvark" ))

Do I need a SELECT statement?

Alan

 

[Golom]

You need a VALUES clause

INSERT INTO [Schema] ( SchemaName, SourceFileType, SourceSheet, SourceDelimiter, DateStamp,UserID ) 

VALUES ( 'Beattles_schema', 'xls', 'PROFILES-_Sample.xls', 'Excel', #12/20/2006 08:37:01#, 'aardvark' )

 

[MacroAlan]

Perfect! Thanks!

Alan