# MS access

**URL:** <https://forums.teamphoenixrising.net/t/ms-access/16316>\
**Category:** Coding and Design\
**Created:** [28 February 2008 11:48 UTC](https://forums.teamphoenixrising.net/t/ms-access/16316 "2008-02-28T11:48:37Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Damski](https://forums.teamphoenixrising.net/letter_avatar_proxy/v4/letter/d/aca169/32.png) [@Damski](https://forums.teamphoenixrising.net/u/Damski)\
**Post date:** [28 February 2008 11:48 UTC](https://forums.teamphoenixrising.net/t/ms-access/16316/1 "2008-02-28T11:48:37Z")

</div>

OK, Who can tell me how I can put the records from a Query into a table that already has data in it? at the push of a button?

---

<div class="post-metadata">

**Author:** ![Damski](https://forums.teamphoenixrising.net/letter_avatar_proxy/v4/letter/d/aca169/32.png) [@Damski](https://forums.teamphoenixrising.net/u/Damski)\
**Post date:** [29 February 2008 12:57 UTC](https://forums.teamphoenixrising.net/t/ms-access/16316/2 "2008-02-29T12:57:39Z")

</div>

Ended up with this

sqlstr = “INSERT INTO [det\_done] SELECT \* FROM [Det\_Nom2]”  
DoCmd.RunSQL sqlstr

I had to ensure all the field names were the same then it worked.

---

<div class="post-metadata">

**Author:** ![Kevin](https://forums.teamphoenixrising.net/letter_avatar_proxy/v4/letter/k/2acd7d/32.png) [@Kevin](https://forums.teamphoenixrising.net/u/Kevin)\
**Post date:** [29 February 2008 13:09 UTC](https://forums.teamphoenixrising.net/t/ms-access/16316/3 "2008-02-29T13:09:28Z")

</div>

If the column (field) names are different you could try:

sqlstr = “INSERT INTO [det\_done] (Col1, Col2) SELECT Col3, Col4 FROM [Det\_Nom2]”

which works in SQL Server.

---

<div class="post-metadata">

**Author:** ![Scream](https://forums.teamphoenixrising.net/letter_avatar_proxy/v4/letter/s/3ab097/32.png) [@Scream](https://forums.teamphoenixrising.net/u/Scream)\
**Post date:** [29 February 2008 16:14 UTC](https://forums.teamphoenixrising.net/t/ms-access/16316/4 "2008-02-29T16:14:07Z")

</div>

why not just make the query into an append query that adds it to the relevant table?

---

<div class="post-metadata">

**Author:** ![Damski](https://forums.teamphoenixrising.net/letter_avatar_proxy/v4/letter/d/aca169/32.png) [@Damski](https://forums.teamphoenixrising.net/u/Damski)\
**Post date:** [29 February 2008 19:18 UTC](https://forums.teamphoenixrising.net/t/ms-access/16316/5 "2008-02-29T19:18:24Z")

</div>

The query was generated / modified by Sql, the query is dynamic so using an append query wouldn’t work. I didn’t think the insert into would work initaly but it seems to work fine.

Be prepaired for more silly SQL / Access questions over the next few weeks as I’m building the biggest database I have to date at the mo. Monster project and only 8 weeks to do it in.

---

<div class="post-metadata">

**Author:** ![STEP2000](https://forums.teamphoenixrising.net/letter_avatar_proxy/v4/letter/s/db5fbb/32.png) [@STEP2000](https://forums.teamphoenixrising.net/u/STEP2000)\
**Post date:** [12 March 2008 14:25 UTC](https://forums.teamphoenixrising.net/t/ms-access/16316/6 "2008-03-12T14:25:11Z")

</div>

DAMSKI…Just IM me with questions anytime…I have a huge Library of VBA/ACCESS/VB Code in office.

Regards,  
Greg (STEP2000)

---

<div class="post-metadata">

**Author:** ![Noel](https://forums.teamphoenixrising.net/letter_avatar_proxy/v4/letter/n/0ea827/32.png) [@Noel](https://forums.teamphoenixrising.net/u/Noel)\
**Post date:** [12 March 2008 17:57 UTC](https://forums.teamphoenixrising.net/t/ms-access/16316/7 "2008-03-12T17:57:28Z")

</div>

Mega programming man Above me 😉
