SQL to export query into table

  • Thread starter Thread starter mario
  • Start date Start date
M

mario

Is there an SQL code or command in MS Access that allows me to export query
results into an table. I'm not worried about the redundancy part as it's a
small table. The problem is, I am not able to update a table using data from
a querry that has joins with other table.

Thanks
 
Is there an SQL code or command in MS Access that allows me to export query
results into an table. I'm not worried about the redundancy part as it's a
small table. The problem is, I am not able to update a table using data from
a querry that has joins with other table.

Thanks
Click to expand...

Sure; an Append query:

INSERT INTO targettable(field, field, field)
SELECT field, field, field FROM <wherever>

By using appropreate joins and indexes you can prevent adding duplicates.

Update queries involving joins CAN work - not all queries are updateable, but
most are. What specific query is failing to update for you? Could you post the
SQL view? It may be fixable.
 
Back
Top