HomeForum
Welcome, Guest

Problem with identity field
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Problem with identity field

Problem with identity field 3 years, 9 months ago #551

  • fotovat
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
Hi
I have Sql 2005 express edition and it hase a table with auto identity field.
when I want to import some data from excel file to that table I got this error \"Mandatory field Visitor_ID missing\"

How Can I fix this problem ? I tried to play with \"Keep Identity\" and calculated with 1 but without any successful

Regards

Re:Problem with identity field 3 years, 9 months ago #552

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
Can you try to set mapping type for identity field to \"not mapped\" and let us know the outcome

Mike
  • Page:
  • 1
Time to create page: 0.15 seconds

Testimonials

Within an hour we were able  to populate fact and dimension tables in our datawarehouse using Advanced ETL Processor

P. Jonson

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top