Access 2010: Insert records from Access query into linked SQL table

Question

Hi.  I'm trying to save the results of an Access query with a filter on it into a linked SQL table.  I want this event to take place when a user presses a button on a form which is based on the filtered query.  Please help with a simple example as I'm struggling with the syntax.  Thanks.

Answer 1

Hi. Have you tried using an APPEND query? Just curious...

Answer 2

No.  I'll look into it though.

Answer 3

Okay, it might work for what you need. Just execute the APPEND query in the click of the button. Good luck!

Answer 4

>>>I want this event to take place when a user presses a button on a form which is based on the filtered query.  Please help with a simple example as I'm struggling with the syntax.

According to your description, you could use INSERT INTO statement to add a record or multiple records to a table. This is referred to as an append query.

Multiple-record append query:

INSERT INTO target [(field1[, field2[, …]])] [IN externaldatabase] SELECT [source.]field1[, field2[, …] FROM tableexpression

Single-record append query:

INSERT INTO target [(field1[, field2[, …]])] VALUES (value1[, value2[, …])

For more information, click here to refer about INSERT INTO Statement (Microsoft Access SQL)