Syntax error in "insert" statement

  • Thread starter Thread starter Paul Janofsky
  • Start date Start date
P

Paul Janofsky

I am trying to insert a record into a table
called "Amortization" using the following insert
statement:

insert into Amortization values(1,2,3,4,5);


I am getting a syntax error when compiling the VBA code.
I've tried all sorts of combinations of quotes, used the
column names, etc. Nothing works. Any help would be
appreciated.
 
You need a field list for this syntax.

INSERT INTO Amortization
(FieldA,FieldB,FieldC,FieldD,FieldE)
Values (1,2,3,4,5)
 
Back
Top