Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft Office 365 For Beginners 2022 8 In 1

Authors: James Holler

1st Edition

B0B2WRC1RX, 979-8833565759

More Books

Students also viewed these Databases questions

Question

6. Identify characteristics of whiteness.

Answered: 1 week ago

Question

e. What are notable achievements of the group?

Answered: 1 week ago