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

Cant Import Records into a sql table

hi,
I am trying to import an excel file into an sql table using ms access, however i am getting the attached error...
Is there a way to find out what exactly is preventing those records from being imported?
(I have tried looking into sql profiler, but didn't see anything under error column)
1-28-14.doc
0
bfuchs
Asked:
bfuchs
  • 4
  • 3
2 Solutions
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I don't see anything on the Word Doc. Just post a screenshot (image) of the error message. Many Experts won't even review your Word document ...
0
 
Surendra NathTechnology LeadCommented:
looking into the error it says it missed 1311 records due to key violations.

The only thing that I can think of is the primary key on the table... check what is the primary key on the table into which you are loading this data

and check if there are any duplicates with the primary key criteria and remove them from the input file.
0
 
bfuchsAuthor Commented:
hi, i think Surendra may be right...
however i am still unable to add those records due to the following
1-28-14.doc
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
bfuchsAuthor Commented:
Hi Scott,
How do you insert an image?
when i click on the image icon above, it saves as attachment as you see above.
by right click/paste it doesn't work either.
0
 
Surendra NathTechnology LeadCommented:
instead of you going back and forth, can you give us your input file here and also the create table script that you used to create the SQL table.

This will help us to pin point the issue and provide you a reliable solution quickly from both the ends.

if that is not feasible due to the red tape of your company (cofidential data ) then what you can do is something like below

1) see 34726 is an id right, check 34726 exists some where else as well, you have to remove it to get it to working.

you have to do it  too all the records, it is easy once you sort that in EXCEL by Id and check for duplicates over there.
0
 
bfuchsAuthor Commented:
Hi Serendra,
This latest error seems to be just a setting in the database (identity_insert), how do i set this on?
0
 
Surendra NathTechnology LeadCommented:
you have to use the below command to do it

SET IDENTITY_INSERT <your table name> ON

Open in new window

0
 
bfuchsAuthor Commented:
thank you!
(however i am facing now another obstacle to this insert, i guess will post another question)
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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