ei guys,


question, how do i insert multiple rows, (around 40, perhaps) into the same table)
with new primary keys eg.

existing rows

(primary keys being field 1 and field 2)

field 1 field2 field 3

00 a data1
00 b data2
00 c data3

rows to insert to look like this

01 a data1
01 b data2
01 c data3

not sure i understand the question

just go ahead and do the insert as normal

I just felt there must be some way for me to copy something like a thousand rows, with 8 - 10 fields each

into a new set of thousand rows with different primary keys from the previous, but exactly the same value in other fields

yes, it's possible, but where would the different primary key values come from?

i can just append something to the existing primary key... but i'm confused as to how the form of this query would be... hope you won't mind giving me that?

try this --

aha, i think i see where my problem was

i was using INSERT INTO table () values (SELECT ...);

many thanks, i guess i'm still a big baby with query manipulation, bad dragdown habits from MSAccesss still here

you cannot say INSERT INTO table () values (SELECT ...) in msaccess either