RE: Insert Statement Syntax

To further explain, in mysql an insert statement used this syntax:

INSERT INTO <table> SET <field>=<value>, <field>=<value>...

But in Access the syntax is:

INSERT INTO <tabl>(<field>,<field>,...) SELECT <value> AS <field>, <value>
AS <field>, <value> AS <field>...

Maybe that clarifies what I was asking a bit more, even though I've already
found the answer. :)
.

Loading