I'm working on a project with a friend. He has an old dBase IIIReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10281-adding-auto-numbered-primary-key-imported.html
database he wants to convert to Access. It's mostly names and addresses
for a mailing list for a newsletter. Importing the table was no
problem. My problem is that I'd like to assign an Auto-Numbered Primary
Key to the table, but Access 2003 won't let me.
How can I import the data and provide an auto-numbered Primary Key as
well? Access won't let me use an auto-numbered key.Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10281
I've tried to create a new table with a primary key then tried to
import the data into the table, hoping that it would automatically auto
number it, but it only imports the table as a whole, not just the data
within the table.
For some background: I've created databases before (mostly mailing
lists with sorting filters, etc) and my knowledge of Access falls
somewhere between beginner and intermediate (closer to intermediate),
but I have no SQL or VBScript knowledge.
Viken K. http://www.vikenk.com