Okay when I try to import the file without the ID column I keep getting an error that just says unspecified error when I try to import it with the ID field but without a value in it I get the error that states that ID cannot be inserted.
What I'd like to do is allow users to upload their excel spreadsheet via an asp page and then have SQL Server import that data into an existing SQL Server table. The problem that I'm running into is that I have a field within my table which is named ID and it is my primary key which is also set...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.