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
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
Scott McDaniel (EE MVE )
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 ...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hi, i think Surendra may be right...
however i am still unable to add those records due to the following
1-28-14.doc
however i am still unable to add those records due to the following
1-28-14.doc
ASKER
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.
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.
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.
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.
ASKER
Hi Serendra,
This latest error seems to be just a setting in the database (identity_insert), how do i set this on?
This latest error seems to be just a setting in the database (identity_insert), how do i set this on?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you!
(however i am facing now another obstacle to this insert, i guess will post another question)
(however i am facing now another obstacle to this insert, i guess will post another question)