Primary key bulk record insert

[Dineedshelp]

PLEASE HELP!!!!!!!

This is driving me crazy!!!! Basically I am creating a database to monitor various forms that we send out. These forms all have indiviual numbers which I'm going to use as a primary key. The forms are produced in bulk. Is there anyway I can enter the numbers in one go (ie five hundred at a time), rather that enter the form numbers one by one (painful at best!!!!)

Thanks!!!

 

[lupins46]

You could write a loop in VBA to populate the table. But what value would it have? You would then be faced with finding a specific record when you wanted to enter the data- and how would you do that - by keying in the form number I guess!

 

[Dineedshelp]

Is there an easier way? Me and VBA don't mix!!!!

 

[lupins46]

Create the list in Excel and import it.

 

[Dineedshelp]

Thanks!!! Makes life easier for me!!!!