求助?如何将数据库每个字段以固定长度写入文本文件中?现在是以逗号分隔写入文本文件中的,但是不美观。想每个字段以固定长度写入就可以了。
1,123,0001,00123456,1,83199201,2005-12-31 9:43:19,
2, , , ,1,13306402666,2005-12-31 14:45:33,
3,35786,5,00123456,1,83194578,2005-12-31 16:02:29,
4,12345678,12345678,678,1,82635446,2006-1-7 9:34:58,
5,123,0001,00123456,1,82635421,2006-1-7 9:35:59,
1,123,0001,00123456,1,83199201,2005-12-31 9:43:19,
2, , , ,1,13306402666,2005-12-31 14:45:33,
3,35786,5,00123456,1,83194578,2005-12-31 16:02:29,
4,12345678,12345678,678,1,82635446,2006-1-7 9:34:58,
5,123,0001,00123456,1,82635421,2006-1-7 9:35:59,
根据字段的长度加入适当数量的制表符。Dim strTmp As StringstrTmp = rs!Field1 & String(3, vbTab) & rs!Field2 & String(3, vbTab) & rs!Field3==========================
免费的学习、交流、源码、工具下载网站,欢迎大家访问!
http://www.j2soft.cn/
取字段的大小来定位置,因为内容不可能大于字段本身定义的长度。
1 ,123 ,0001 ,00123456 ,2005-12-31 9:43:19,
2222 ,23232 ,ds ,erere ,wwew ,把需要处理的字段strData 放到:
IIf(Len(strData)) < 10, strData & Space(10 - Len(strData))
处理一下就ok了