does anybody know of a full proof way of migrating data from excel to sql server using stored procedures especially where the data may contain hidden characters especially spaces

Ade

the given answer to this question is incorrect because the string variable contains 9 characters including the commas and spaces. Total length through first function being 9 - 2...

The article is missing all its screenshots, would it be possible to republish the page again

excellent question using left and right and the modulus sign .only problem remember to take the remainder for the answer not the amount left after a divide to a whole...

The section about the FullSun SQL Server Toolkit sounds excellent, the only problem being clicking on the hyperlink connects to the URL http://www.fullsun.net but with no web pages?...