What is the best way to accomplish this?
I work frequently with excel sheets, hundreds of thousands of rows deep, containing data that needs to be converted for and imported into SQL databases. The biggest obstacle in these processes is almost always the string length constraints on the SQL side that need to adjust the Excel data to. As of now, what i typically do is write the queries to import the data accordingly and then deal with the truncation issues after the first execution of the query within SQL, because, at that point, i get to see where my strings over-run.
What i would prefer to do, is to be proactive. I would like to identify each rown in a column that has a string length beyond a designated value. That way, i can make the necessary adjustments on the excel side before writing the query for SQL. Are there any recommendations out there as to what i can do in Excel to identify the string length in rows and specifically show me string lengths beyond what i identify as tolerable?
thanks
james
I work frequently with excel sheets, hundreds of thousands of rows deep, containing data that needs to be converted for and imported into SQL databases. The biggest obstacle in these processes is almost always the string length constraints on the SQL side that need to adjust the Excel data to. As of now, what i typically do is write the queries to import the data accordingly and then deal with the truncation issues after the first execution of the query within SQL, because, at that point, i get to see where my strings over-run.
What i would prefer to do, is to be proactive. I would like to identify each rown in a column that has a string length beyond a designated value. That way, i can make the necessary adjustments on the excel side before writing the query for SQL. Are there any recommendations out there as to what i can do in Excel to identify the string length in rows and specifically show me string lengths beyond what i identify as tolerable?
thanks
james