Auto numbering

  • Thread starter Thread starter Mauricio
  • Start date Start date
M

Mauricio

I have imported a table from foxpro and now I want the
primary field in Access to be autonumbering but following
from the last number of the imported table...how can I do
it?
 
You can import data into an AutoNumber field, but you cannot change it to an
AutoNumber afterwards.

1. In the Database window, choose the imported table. Copy (Ctrl+C). Paste
(Ctrl+V). Give a new name, and choose:
Structure only.

2. Open the new table in design view. Delete the number field. Save. Add a
new field of type AutoNumber, using the same name if you like. Save.

3. Create a query into your old import table.
Change it to an Append query (Append on Query menu), telling Access to
append to the new table. Run the query.

You now have the old data imported into the table with the AutoNumber field.
 
Back
Top