Syntax error in "insert" statement

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.
 
J

John Spencer (MVP)

You need a field list for this syntax.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top