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

Using VB Code, create an Autonumber and then create a primary key on that field...

P: 6
I am attempting to create a module that I can call to create a new field in my temp table that will be an autonumber, and then assigned that new field as the primary key. I have been search high and low for the code, it seems like an easy task but haven't solved the problem yet. Here is the current scenario: I import an text file of numbers, once imported, I need to assign a unique (autonumber) value to each number imported, starting with 1 to however many numbers were imported and maintain the order in which the numbers were imported!!! Hopefully this isn't too confusing....Thanks again
Sep 16 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 5K+
P: 8,127
are you trying to store the data into a database table ?
Sep 16 '08 #2

Post your reply

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