Loop: Import data while giving each row a running number(1,2,3 ...

A

ali

I have a linked table name Table1:


Tabl1:
NAME Nationality

James Japan
Yuri Russia
Steve GB
Dunst USA

----------------------------------------------------------
Question:

I want to import these name into an empty table (tb_all) in my MS Access
while giving each row a running number from "1" (2,3,4 ... onwards)


so that result should be

tb_all:
Running_number Name Nationality
1 James Japan
2 Yuri Russia
3 Steve GB
4 Dunst USA
 
A

ali

Hi Paolo,

thanks for your reply.
However, this is not working. will you test it again

thanks alot!
 
Top