Timeline for SQL Server Import Wizard Excel into SQL Server 2016 Error 0xc020901c
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 23, 2017 at 12:40 | history | edited | CommunityBot |
replaced http://stackoverflow.com/ with https://stackoverflow.com/
|
|
| Apr 27, 2017 at 16:28 | history | edited | BradC | CC BY-SA 3.0 |
Added link and further ideas.
|
| Apr 27, 2017 at 16:19 | comment | added | BradC | @JoshEblin Yeah, that's an Excel quirk, it doesn't always adjust the "active region" when you delete data at the end of a list. Glad it helped, I'll edit that part into my answer, since that is what worked for you. | |
| Apr 27, 2017 at 16:07 | vote | accept | Josh Eblin | ||
| Apr 27, 2017 at 16:06 | comment | added | Josh Eblin | @BradC every column in that table is required. In the wizard "Edit Mappings..." screen, I have made sure that there are no "Nullable" boxes checked. I even went so far as to try to check one and uncheck it, only to find that it wouldn't let me check the nullable box for any of the columns. I imagine that's because they are all required fields. All that said, I tried the "delete rows below the data in the spreadsheet" suggestion from the link you posted, and that worked. My only guess is that because those rows previously had data, it was causing issues on the import. Thanks for the help. | |
| Apr 27, 2017 at 15:31 | comment | added | Erik Reasonable Rates Darling | It's not a foreign key, is it? | |
| Apr 27, 2017 at 15:30 | comment | added | BradC |
@JoshEblin Hmm. Check out the ideas in this Stackoverflow link, then. It might be trying to import some extra blank rows, which you can either allow (by changing the ALLOW NULLS option), or pipe the failed rows into a different dataset in SSIS, to handle the failing rows separately.
|
|
| Apr 27, 2017 at 15:25 | comment | added | Josh Eblin | In both spreadsheets, the approval number is a uniform format XX1234567 (2 letters, then 7 numbers). The datatype of the Approval number column in SQL is varchar(9). I have run multiple formulas in excel to make sure that all approval numbers are 9 characters and that none of them are duplicated. | |
| Apr 27, 2017 at 15:07 | history | answered | BradC | CC BY-SA 3.0 |