Hi All, I would like to know if it is possible to renumber an auto number
field, I know this is scoffed upon and goes against the principals of
database management, but i would really like to know if it can be done. I am
currently using data imported from an excel sheet which my company uses for a
tracking system, I intend to start a fresh table when I have finished writing
and testing the database so would like this new table to start at a number
beyond the current excel sheet.

What is the easiest way to start the new table at 20000

Thanks