|
Replies:
1
-
Pages:
1
-
Last Post:
Feb 25, 2013 2:42 PM
by: Robert Dannels
|
Threads:
[
Previous
|
Next
]
|
|
Posts:
1
Registered:
2/18/13
|
|
|
|
CSV import question
Posted:
Feb 18, 2013 10:26 AM
|
|
|
I can't seem to figure this out. I have a primary key ID field in my table. I am trying to import a CSV file that has all of the other fields in it, except the ID field. This is an autoincrement field, so whenever I import the data, it should just put in an ID number that is next in line. I get an error saying that the ID field can't import Null Data. I tried to uncheck the box that says blank fields are null, and it still didn't work? This will be real pain if I have to go in and manually ID every CSV that I need to import.
|
|
|
Posts:
1
Registered:
2/25/13
|
|
|
|
Re: CSV import question
Posted:
Feb 25, 2013 2:42 PM
in response to: kefob
|
|
|
Have you set AUTO_INCREMENT on your primary key?
Robert
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
