摘要:
Use ADO and the Jet OLEDB provider, which can read the contents of excel files without actually opening Excel.Example:'*******************************PublicSubConvertXLSToTab(ByValxlsFileNameAsString,ByValtabTextOutputFileAsString)DimconnectionStringAsString="Provider=Microsoft.ACE.OLEDB.12 阅读全文