• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 919
  • Last Modified:

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?
0
Braveheartli
Asked:
Braveheartli
  • 3
  • 2
  • 2
  • +1
5 Solutions
 
BraveheartliMarketingAuthor Commented:
I use mdb data base.
0
 
rashmi_vaghelaCommented:
0
 
rashmi_vaghelaCommented:
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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
 
BraveheartliMarketingAuthor Commented:
id colloumn is empty,
I put the id's on the exel file, then I import it, then it works,
0
 
BraveheartliMarketingAuthor 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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now