Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is there any way to import this table so the serial number field becomes an autonumber field?

April 26, 2017autonumber field import serial Table

0

Posted

Is there any way to import this table so the serial number field becomes an autonumber field?

1 Answer

0

Posted

Or is there any way to get the autonumber field to match the value in the serial number field? Re: Import Autonumber Problem “Jeff Boyce” 12/30/2008 2:51:05 PM David You are (mostly) correct in assuming that you can’t stuff your serial numbers into an Access Autonumber field … after all, “autonumber” means Access automatically assigns the number! But there’s no reason you couldn’t have an Autonumber field in Access that you (and Access) would use as a primary key, and a second field of a data type compatible to your serial number, which you COULD stuff. I mention “compatible” because some folks would call “A1Z339#2” a “serial number”, even though you’d never try to do math on it (therefore, it isn’t really a “number”, but a text string). And you can use indexes to ensure that no two serial numbers are the same… (however, and you haven’t described your situation enough for us to know this, if you used items from more than one manufac