需要配置Schema.ini参考: How to Use Schema.ini for Accessing Text Data: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q149/0/90.asp&NoWebContent=1HOWTO: Use RDO and ODBC Text Driver to Open a Delimited Text: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q187/6/70.asp&NoWebContent=1
方法2:先全部读入内存,取得长度,让后用Replace将vbCrLf替换为"",再取得长度,将两者的差除以2即可
怎样打开,好像我打开的时候说格式不对。
How to Use Schema.ini for Accessing Text Data:
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q149/0/90.asp&NoWebContent=1HOWTO: Use RDO and ODBC Text Driver to Open a Delimited Text:
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q187/6/70.asp&NoWebContent=1