Hi
I am using ms access 2013. Often in my organization an excel sheet with the data needs to be imported in ms access for official use. While creating reports before that i want a table to have a serial number.So i add a field in the working table but i cannot populate the rows with serial number say starting from 1 2 3 4 5 6 .......100.
I have to populate it manually. Now the case came that it has 84000 rows. so i cannot insert it manually. Can some one tell me a query or VBA code to insert it.
Regards
I am using ms access 2013. Often in my organization an excel sheet with the data needs to be imported in ms access for official use. While creating reports before that i want a table to have a serial number.So i add a field in the working table but i cannot populate the rows with serial number say starting from 1 2 3 4 5 6 .......100.
I have to populate it manually. Now the case came that it has 84000 rows. so i cannot insert it manually. Can some one tell me a query or VBA code to insert it.
Regards
Comment