I have created a Sql Server Object CreateObject('SQLDMO.SQLServer') Every thing is working great except for when we do a ExecutewithResult function I write it to a text file. but I want to import it into a table. I can't figure out how to tell what the decimal and length is for data types number or floats or integers. The numericpercision and numericscale allways returns 0, the length returns 8 but I think that is how much space it uses to store the info - Like integers use up 4. We are using SQL 7.0 has any one done this before?