auto increment number mdb database

I have a database,  the first colloumn is ID and it is auto increment.
when I import new data from my excel file it doesn't create an automatic id number,
what should I do?
LVL 1
BRMarketingAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BRMarketingAuthor Commented:
I use mdb data base.
0
rashmi_vaghelaCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rashmi_vaghelaCommented:
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

peter57rCommented:
"when I import new data from my excel file it doesn't create an automatic id number,"

so what does it do - what numbers are allocated?

0
BRMarketingAuthor Commented:
id colloumn is empty,
I put the id's on the exel file, then I import it, then it works,
0
BRMarketingAuthor Commented:
when I mean it works, it doesn't create it's own number, it gets the id number from the excel file, which is the same..
0
peter57rCommented:
You should not be importing the id number.  If you do that Access will accept what it is given.
0
exx1976Commented:
+1.  Check your import file to make sure you don't have a blank ID field.  You shouldn't have that on there at all, otherwise you're going to get a blank ID in your database.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.