Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I have to add rows of data to a table that includes a phone number column, which is currently set to (int, not null). This
I have to add rows of data to a table that includes a phone number column, which is currently set to (int, not null). This is my SQL query Use CSUGlobalEdu GO BULK INSERT Student FROM '\\denm1bnas01\sisnet1\Student.csv' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = ' ' ); GO This is the format that the phone #s are in: 3035551212 I'm getting the following error msg: Msg 4864, Level 16, State 1, Line 1 Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 3 (PhoneNumber).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started