Copy table to table, how?

[phiber102]

Hello!

I been working on a problem for a while. I need to copy data from 2 tables and merge them in to 1 table that already exists. i need to extract a column called "bpo" and a column called "usr" from 2 different tables called anv and bpo and then copy them into a table called mybpo.

I guess it shood look something like this:

sql = "INSERT INTO mybpo SELECT usr FROM anv where usr ='" & session("usr") & "' and SELECT bpo FROM bpo "

but i cant get it to work, tried allot of combinations, Please help me

/Regards Phiber

[ck9663]

Merge as in JOIN or merge as in UNION?

-- CK

[phiber102]

Hmm not not really sure, since im not that good at sql/database part :D

But what i want is to take data from table "anv" column "usr" and then take out data from table "bpo" column "bpo", and place them into a table called "mybpo" column "usr" and column "bpo". and its important that usr and bpo enter "next to each other"

[ck9663]

That looks like a JOINED table. Find a key that can be used to link the table, then read this


-- CK

[phiber102]

Thank you very much! might have saved my day :D

[phiber102]

hmm i still cant get it to work, doing this now:

sql = "INSERT INTO mybpo SELECT bpo FROM bpo JOIN anv ON (usr = '" & session("usr") & "')"
 

but then i get error message Microsoft JET Database Engine (0x80040E14)

[ck9663]

1. Display the value of the variable sql.
2. Copy the displayed value
3. Open a query window
4. Paste the value of sql
5. Execute your query.

And check your syntax

-- CK

[phiber102]

thx again :D appreciate the help