I am trying to do a Bulk insert of a CSV file into SQL. I tested on dummy database using a created CSV file and got it working.
But the actual CSV file that has arrived has " around the name
eg "Hollywood". The Database has a fixed field length of 9 therefore the convert fails as the above...
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.