By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,896 Members | 1,983 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,896 IT Pros & Developers. It's quick & easy.

How can I automatically add an Autonumber field to a table in Access 2007?

P: 3
I will need it to be in VBA, since I need to put it in an Access 2007 database and execute it with an Access macro.

What I am doing is using a utility to find the hard drives' conditions on computers and list them in a text file sequentially. The utility does not list numbers or drive letters. So I need to put some kind of identifying information on the entries so I can put them in the appropriate spot in the Access Database record.

I need the number to come out as such:
First record found | 1
Second record found | 2
and so forth.

Thanks for your help.
Apr 9 '08 #1
Share this Question
Share on Google+
1 Reply


P: 3
I figured it out. Instead of appending the imports to an existing table, I can Import them as new tables, let Access add a primary key, and then automate the imports.

Thanks anyway.
Apr 9 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.