Microsoft SQL2000 Databases

I have a database created in MS SQL2000 that will require the entry of 48,000 ID numbers. The numbers start at 1B0001 thru 1B8000.Then 2B0001 thru 2B8000 upto and including 6B8000. Is there any method that would allow me to create the 1B series and the others similar to the method I used in Excel to list the ID numbers on a spreadsheet? 1B0001, 1B0002 then highlight the two boxes and drag the curser down the column until I reached the 1B8000 box and have the numbers listed in series automatically? It takes on adverage and hour to enter 500 ID numbers when I go into the SQL database and add the ID number.